Formula not Return Required Answer Q
Worked it
"John" wrote in message
...
I have the following formula, which returns an unexpected answer
=IF(AND(G11="Off",G140),"Not Expected
In"),IF(OR(F13="",F14=""),"",IF(AND(G120,G14<=0), "No
Show",IF(ISERROR(IF((F13-F$7)F11,"In Late","")),"",IF((F13-F$7)F11,"In
Late",""))))
My Data contains the following
G11=Off
G14=contains a value 0
F13=contains a value
F14=contains a value
G12=0
G14=is greater than Zero
F7=contains a value
F11=blank
With my data above, I expect my formula to return "Not Expected In" as
both G11 and G14 conform to the first part of my formula.
The answer actually returned is "Blank". Do I have a bracket missed out or
in the wrong place?
Thanks
|