Getting subtraction wrong in excel

Question

This is absurdly simple but I am not getting what I am doing wrong, please help me out. My formula is very simple:=V40 - SUM(O40:P40,R40:S40)

The values of V40 is 107, O40 is 80, P40 is 0, R40 is 1, S40 is 0. Ideally, the result should be 107 - 81 = 26, but no matter what I do the result that comes is 0

Answer 1

1. If your values are a result of other functions check if the formulas for these functions still hold true, if not correct them.
2. Try recreating the same formula in different parts of the worksheet/workbook, if the formula works then an error is isolated to the cell where you are getting the results.
3. Try with static values in the formula instead of dynamic, if the problem still pertains then the issue is with the cell.
4. ** Check the format of the cell** Change it to number format.
5. ** Check whether the calculations for the sheet/workbook are set to automatic instead of manual**

I hope this helps you.