WildbloodS
Technical User
Hi, any help most welcome with correcting a formula where I am trying to evaluate several codes in Column G
Depending on what code exists in column G I would like to check if either column I or Column J contains data.
If data exists based on those criteria, I would like in the target cell to return "Passed Check 1", or, "Failed Check 1".
However:
With this code I get the return FALSE
=IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001"),IF(COUNTBLANK(J4),IF(OR(G4="JZ135RTK0001"),IF(COUNTBLANK(I4),"Failed Check 1","Passed Check 1"))))
With this code I get the return #VALUE
=IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001"),IF(COUNTBLANK(J4),"Failed Check 1","Passed Check 1"),"Not Applicable"),IF(OR(G4="JZ135RTK0001"),IF(COUNTBLANK(I4),"Failed Check 1","Passed Check 1"))
- I would normally use Access to do all this quite comfortably, however, I've been asked to put this together quickly using Excel.
Thank you
Depending on what code exists in column G I would like to check if either column I or Column J contains data.
If data exists based on those criteria, I would like in the target cell to return "Passed Check 1", or, "Failed Check 1".
However:
With this code I get the return FALSE
=IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001"),IF(COUNTBLANK(J4),IF(OR(G4="JZ135RTK0001"),IF(COUNTBLANK(I4),"Failed Check 1","Passed Check 1"))))
With this code I get the return #VALUE
=IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001"),IF(COUNTBLANK(J4),"Failed Check 1","Passed Check 1"),"Not Applicable"),IF(OR(G4="JZ135RTK0001"),IF(COUNTBLANK(I4),"Failed Check 1","Passed Check 1"))
- I would normally use Access to do all this quite comfortably, however, I've been asked to put this together quickly using Excel.
Thank you