Hi
Any help greatly appreciated before my head hits the desk..
I need a formula that says IF L3 is greater than 1 but less than D4, "ADVISORY" but if L3 is greater than D4, "FAIL". Additionally, if L3 is less than D4 but d2 is greater than f2, "ADVISORY" otherwise "PASS"
I hope that makes...