I need an If statement for Excel that excludes empty cells

N

nascar2000a

I have a column of data (B11:B36) with a Min (B9) and Max (B10). I need an IF
statement that says pass if all data is within the Min/Max and fail if
outside the Min/Max but excludes blank cells.
 
P

PCLIVE

You may need a helper column. For example, use this formula in D11 and copy
down.

=IF(B11="","",IF(AND(B11>=$B$9,B11<=$B$10),"Pass","Fail"))

Then you can use a formula to see if there are any "Fail"s in column D.

=IF(COUNTIF(D11:D36,"Fail")>0,"Fail","Pass")

Regards,
Paul
 
N

nascar2000a

This worked great I just had to add an = to the Min and Max statements.

Thanks
 
Top