Forum Discussion
Excel not accepting zero from the formula in my spreadsheet
Hi Everyone,
Appreciate if someone can please help me on this.
Cell F4 (red) is based on the formula in cell F3 (yellow).
It should show up as zero but does not do so. If I get rid of the formula and type zero as a number instead, it works fine.
I look forward to some advice on how to fix this issue.
Regards,
Sosheel
6 Replies
- Thanks much appreciated
Hi,
in your formulas, your a using "0" as result for some IF statements. "0" is seen as a string/text, not a number. Change "0" to 0 and it should work.
Best,
Mourad
- Thanks a lot
Sosheel_Godfrey You need to change your formula from =IF(F3=0,"0",E6+F3)
to
=IF(F3="0","0",E6+F3)
By including the "", you're telling system that as long as end value is 0, I want it to be 0.
MsC0101 thanks, mate. This is a great help. Appreciate it
