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: 8 Responses to “An Introduction To Using Formulas In Mac Numbers”

    Ric
    4 months ago

    Thanks for the refresher.

    Isabel Ruttle
    4 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!

    4 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
    4 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?

    4 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
    4 months ago

    Thanks, Gary Shall do!

    Leo
    1 month 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???

    1 month ago

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

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)