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?

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

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

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