If statement (Ignore blank)

[lisadang]

Hi,

Can someone help me with this formula?

When I update J6 with a "0", it increases the result of the cell that this formula is in.

How do I change it so that if J6 has a 0, it doesn't change the value of this cell?

Please Login or Register  to view this content.

[daddylonglegs]

Try

=IF(J6=0,(E6-(E6*K6))/D6,E6/D6)

[shg]

Or =IF(J6=0, 1-K6, 1) * E6 / D6