How do you use a blank in a formula in Excel - If a1 is blank

O

ottodesque

I have a formula =(IF(U7<100,"Fail","Pass") posted in cell T7 but if U7 is
blank T7 is populated with Pass. If U7 is blank I need T 7 to be blank as
well.
 
E

Eduardo

Hi

=if(U7="","",if(u7<100,"Fail","Pass))

If this was helpful please click yes, thanks
 
E

Elkar

You can do a nested IF function. Like:

=IF(U7="","",IF(U7<100,"Fail","Pass"))

The second IF is "nested" inside the FALSE portion of the first IF.

HTH
Elkar
 

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

Maintaining a cells value once a target is achieved 9
Nested if statements creating a blank cell 1
Choose function in Excel 2003 6
Dealing with the error: unable to filter on excel hc home school 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Autofill cell reference forumula not working 4
Help! Need to ignore 0s and blank cells in average formula! 2
If Not blank - Formula for two cells 0

Top