An Introduction To Using Formulas In Mac Numbers

Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.


Comments: 10 Responses to “An Introduction To Using Formulas In Mac Numbers”

    Ric
    10 months ago

    Thanks for the refresher.

    Isabel Ruttle
    10 months ago

    This came at just the right time for taxes! However, I continue to get '0' as my answer when adding a column. The formula looks right, but, when I press the check mark, the answer is '0'.

    I type'=' the formula shows up. I drag the cursor over the column. The cells appear. There are some empty cells in the column. thanks for your help!

    10 months ago

    Isabel: Start from scratch again and follow along closely with what I am doing in the video. You'll get it.

    Isabel Ruttle
    10 months ago

    Me, again. On a new spreadsheet I followed your directions and it worked!I Unfortunately, when I went back to the original the total was still '0'. So, I opened a new SS and copied the information to it. I still get '0'. Oh, and occasionally, when I hit =, it showed up! Now what?

    10 months ago

    Isabel: Troubleshoot. Use your deduction skills to figure out what is different. Is there something about the values you are trying to sum up? Maybe they are text instead of numbers. Maybe you have selected the wrong range or there is something included in the range that is not a number. Investigate carefully to find the problem.

    Isabel Ruttle
    10 months ago

    Thanks, Gary Shall do!

    Leo
    7 months ago

    Hey Gary... I have and issue. I need a formula to increase procuct by one for every two people in the household.
    1 person gets 1 item, 2 people get 1 item, 3 people get 2 items, 4 people get 2 items, 5 people get 3 items and so on.
    I do not know what this type of formula is called and need help.. please can you help me???

    7 months ago

    Leo: Sounds like you just want simple math. Divide by 2, round up.

    Andy
    3 weeks ago

    Gary, is there any way to change the default location of the formula edit box after hitting the = key? It appears over the cell being edited, but also over two adjacent cells which I often need to see or select. I realize that the edit box can be moved, but it gets tedious as I frequently have to move this box.

    3 weeks ago

    Andy: No, it will always appear right at the cell.

Leave a New Comment Related to "An Introduction To Using Formulas In 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)