Remove False

[daz01]

Hi. The below simple equation is used on a spreadsheet. Not having used excell properly for a few years, I have forgotton what to add to this equation for a zero to show rather than false when the conditions aren't met.
=IF(M73>P41,M70*0.04)
Cheers Daz

 

[Marcelo Branco]

Try

=IF(M73>P41,M70*0.04,0)

M.

 

[daz01]

Hi.
Thanks for that. It has given me $0 instead of false which is just what I wanted.
Cheers Daz

 

[Scott Huish]

Also:

=(M70*0.04)*(M73>P41)

 

[daz01]

Thanks for that.
Cheers Daz