Excel - Change cell value result from "FALSE" to blank or zero

Asked By JG on 10-Dec-09 04:28 PM
I have the following IF statement written into this cell:

=IF(N6>=1,O6,IF(P6>=1,Q6,IF(R6>=1,S6,IF(T6>=1,U6))))

If cells N6, P6, R6 or T6 all have zeros written into them, cell E6 shows
the value "FALSE".  How can I have this cell have the value 0 under these
conditions?




Fred Smith replied to JG on 10-Dec-09 04:35 PM
Like this:
=IF(N6>=1,O6,IF(P6>=1,Q6,IF(R6>=1,S6,IF(T6>=1,U6,0))))

Regards,
Fred
David Biddulph replied to JG on 10-Dec-09 04:40 PM
=IF(N6>=1,O6,IF(P6>=1,Q6,IF(R6>=1,S6,IF(T6>=1,U6,0))))
--
David Biddulph
Paul C replied to JG on 10-Dec-09 04:43 PM
=IF(N6>=1,O6,IF(P6>=1,Q6,IF(R6>=1,S6,IF(T6>=1,U6,0))))

The last if IF(T6>=1,U6) was missing a value if false, adding the ,0 should
do the trick
--
If this helps, please remember to click yes.