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

J

JG

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?
 
P

Paul C

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested if loop with logical OR/AND 4
Averageif function with range that includes non-consecutive cells 4
custom add formula 7
my first excel experience (share portfolio) 2
Inserting mulitpul Text and a Tab Symbol into a cell 0
Using the COUNTA function 1
#VALUE! error when trying to add cells (VLOOKUP) 6
Help with calculation in query!!! 13

Top