Function Mal-Functioning
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,
|