Just to share some of the tips and tricks when using Apple Numbers. I am not crazy, I mostly use Numbers for personal spreadsheets, not for work. It’s free and easy to use on all my Apple devices, I can easily have more than 5 devices and I don’t want to buy extra licenses for Excel.
- Get crypto or stock price. =STOCKH(“BTC-USD”,0,”2025-01-05″)
- To enter a number in scientific notation. =”1e-3″×1000000
- Using Trendlines in Numbers. Trendline with dates, the intercept x=0 is the first date, in number of days, need to use =DUR2DAYS([Date]−[StartDate]) with the trend formula. (Different to standard Excel default of January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.)
* Reference: https://support.microsoft.com/en-us/office/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252 - You can manually display and copy the trendline equation with R value on the chart. Alternatively, you can calculate a linear equation from the data. For exponential trendline, use this:
y=a*e^bx
ln(y) = bx + ln(a)
Column B as X values and Column C as Y values
Make a new Column D with formula =LN(C)
b = SLOPE(D,B)
a = EXP(INTERCEPT(D,B))
* Reference:
https://discussions.apple.com/thread/252737187?answerId=255150843022
https://discussions.apple.com/thread/8356480?answerId=33284594022
https://discussions.apple.com/thread/252546736
https://www.ablebits.com/office-addins-blog/excel-trendline-types-equations-formulas/
Leave a Comment