Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |