'Getting subtraction wrong in excel [closed]
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
Things that I have tried
- Changed the format of all the cells to Number format
- Tried to use Numbervalue on the formula to get correct value, but no result
=NUMBERVALUE(V40)-NUMBERVALUE(SUM(O40:P40,R40:S40))
PFB the cells in question:
PFB result in Evaluate Formaula :
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|