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