I have this formula in cell D8: =IF(ISBLANK(C8),"",IF(AND(C8<=G8)*C8>=F8,"PASS","FAIL"))
I want the formula in D8 to calculate its result based on the result of a formula in F8 and G8. Can this be done?
The formula in F8 is =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,"0.484",""))
The formula in G8 is =IF(ISBLANK(C8),"",IF(AND(G3=250)*G4=0.5,"0.516",""))
Bookmarks