Isblank(cell) does not recognize cells with formulas as blanks. a workaround
is using (countblank(cell)=1) will give a TRUE when the cell is really blank
or a "" response. Cells showing as blank because of formating (eg ;;; and
the like) will will show as false.
"Jay" wrote:

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,