Excel not accepting zero from the formula in my spreadsheet

[Sosheel_Godfrey]

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

[#2]

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

[#3]

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

[#4]

@Sosheel_Godfrey 

As variant

=MAX(0,ABS($B$1*E6))

=(F3<>0)*(E6+F3)

etc

[#5]

@MsC0101 thanks, mate. This is a great help. Appreciate it

[#6]

Thanks a lot

[#7]

Thanks much appreciated