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...
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
