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

  • Thread starter Thread starter ottodesque
  • Start date Start date
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.
 
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
 
Back
Top