Change FALSE to 0

[yakov2491]

I have a formula that works for what I need it to but in the cell when it should be a 0 value, it shows FALSE.

=IF(D18>0,(E18/SUM(E9:E18))*C8)

Is there an easy way to adjust the formula to show a 0 value instead of a FALSE in the cell?

[pareshj]

Hi,

Try this formula, hope it helps you :

=IF(D18>0,(E18/SUM(E9:E18))*C8,"0")

[Sam Capricci]

change this =IF(D18>0,(E18/SUM(E9:E18))*C8)
to this =IF(D18>0,(E18/SUM(E9:E18))*C8,0)

[yakov2491]

Got it Thank you both.