25 Things You Didn’t Know You Could Do With Mac Numbers

Here are a variety of functions, features and tips for Mac Numbers that many Numbers users don't know about.



Download the example file.

Comments: 8 Responses to “25 Things You Didn’t Know You Could Do With Mac Numbers”

    Eduard Nebbeling
    1 week ago

    Thank you very much for this topic, it’s really helpful when working in Numbers.

    Sue Dickie
    1 week ago

    Very timely. I just looked at the Stocks template yesterday and couldn’t figure out how they had done some calculations. After poking around, I found ‘Previous gain’ in a hidden row. Your video has now shown me more things that I wasn’t aware of, and some will be helpful. As an aside, I wish Apple annotated their templates to explain how they were pulled together.

    John R Carter Sr
    7 days ago

    You just blew my mind with this.
    I’m using Numbers at the very basic level of just showing tabular data.
    I knew that there were many formulas available, and I’ve used some of the math functions. But this goes beyond anything I would need to do! Still, fun to know.

    Ray Johnston
    5 days ago

    Very helpful, Gary. Do you have a way to generate a value for “yesterday” which also skips over holidays? I’d like to use that in a spreadsheet to look at yesterday’s closing stock value, since todays closing value won’t be correct until after the close.

    5 days ago

    Ray: Look at WORKDAYS in the help. You can use a value like -1 and then add your holidays in to get the previous work day.

    Ray
    5 days ago

    Tried that: =WORKDAY(“1/1/21″,-1,”1/1/21″) returns 12/30/20, not 31. Also tried =STOCK(TSLA, previous close), but that seems to return value for two days ago, according to =STOCKH(TSLA,close,”2/18/21”) {today’s the 20th}.

    5 days ago

    Ray: WORKDAY(“1/1/21″,-1,”1/1/21″) probably returns 12/30/20 because you are eliminating 1/1/21 and also going back one more day as well. The other one makes sense because you are asking for the “previous” close, not the current price.

    Ray
    5 days ago

    Thanks, Gary. For my personal finance tracking, those answers work well enough. I think I’ll use the =STOCK( ticker,previous close) function for just a quick look, and perhaps the =WORKDAY( date,-1) function (no holidays) and =STOCKH( ticker,close,date ) for trend tracking.

Leave a New Comment Related to "25 Things You Didn't Know You Could Do With Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)