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

Formula to move from cell to cell 2
Averageif function with range that includes non-consecutive cells 4
my first excel experience (share portfolio) 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
custom add formula 7
nested if loop with logical OR/AND 4
Printing Different Sections of same Sheet 1
Using the COUNTA function 1

Top