Forum Discussion
Excel Subtraction
Good Afternoon, I have always used =sum(cell name-cell name) for subtracting to cells from each other. Now I am setting up the exact same worksheet in a workbook, just a different year and all I get...
Thank you for the response. I entered the formula as you stated, which is the method the Microsoft help suggested. Also, I changed the format to "currency" as I had it set to "accounting". Below is the result of the change. Zero is clearly not the right answer, what do you think could be wrong? I have done this simple spreadsheet for years and never had any problems.
| 5,978.81 |
| 5,171.70 |
| 0.00 |
Tammy
When you apply currency number formating using CTRL + SHIFT + 4 or you click on Currency, the currency in your Regional Settings will be applied. For example $5,978.81
I will suggest you upload the workbook for verification
I will suggest you upload the workbook for verification