Formula not Return Required Answer Q
 

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

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