I have done the formulas for the spreadsheet. However, now I have a negative number to add in, but it won't compute the negative amount. What do I have to do to get it to add the column correctly?
iMac, OS X Mavericks (10.9.2)
gerenahum,
adding up cells can be done a variety of ways. Not know how you have added up the values in several cells makes it hard to propose a specify fix for your situation.
Number will, however, add both positive and negative numbers with no problem.
In my opinion, the easiest way to add up (or sum) cells is to use the sum() function like this:
what you see above is that I have selected cell B2 and typed the formula "=sum(a2:a7)" which means to add up the values in cells A2 thru A7 and present the results in cell B2.
Now I entered some value in cells A2 thru A4 which you can see the "answer" in cell B2 (1 + -1 + 2 does indeed equal 2)
Thank you very much. I shall work on this. I don't do these very often--about every 3 months and it is easy to forget in-between, especially with new questions. I tried another column and the - sign worked. Don't know what happened before.
🙂🙂
How do I use minus and plus values in a spreadsheet?
