Jay,

I suspect you have formulas in I17 and J17 that are returning "", so they
are not really blank.

Try

=IF(AND(I17="",J17=""),"",IF(AND(I17=0,J17=0),"Pas s","Fail"))

HTH,
Bernie
MS Excel MVP


"Jay" wrote in message
...
I have this application that does a couple of things. One though, is being
a
bit problematic. Can some one who has the answer chime in with
corrections?
The problem is this, three columns
1.) Column I3 equal to =IF(ISBLANK(H17),"",IF(H17=4.5,0,$I$2-H17))

2.) Column J3 equal to =IF(ISBLANK(H17),"",IF(H17<=5.5,0,H17-$J$2))

3.) Column K3 equal to
=IF(AND(ISBLANK(I17),ISBLANK(J17)),"",IF(AND(I17=0 ,J17=0),"Pass","Fail"))

The problem is that even if the columns I & J are "" empty (No Value),
column H displays "Fail". What I need is to have no value shown in column
"H"
if all columns to the left are "" (I & J are Blank).

Is it possible to correct this painlessly?

Looking forward to your input.

Thanks,