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

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?

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

Like this:
=IF(N6=1,O6,IF(P6=1,Q6,IF(R6=1,S6,IF(T6=1,U6,0 ))))

Regards,
Fred

"JG" wrote in message
...
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?

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

=IF(N6=1,O6,IF(P6=1,Q6,IF(R6=1,S6,IF(T6=1,U6,0 ))))
--
David Biddulph

"JG" wrote in message
...
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?

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

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


"JG" wrote:

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?