Hi, can anyone help...
I have an IF function showing pass or fail linked to two cells that each contain a formula to arrive at thier number, I am sure it is not too difficult, but I cannot figure this out.
eg. =IF(B7>E7,"PASS",FAIL")
when B7 contains: =E6
and E7 contains: =E9
please help, I can get this working ok if the referenced cells in the formula contain no formula themselves...
Bookmarks