Formula not Return Required Answer Q

J

John

I have the following formula, which returns an unexpected answer

=IF(AND(G11="Off",G14>0),"Not Expected
In"),IF(OR(F13="",F14=""),"",IF(AND(G12>0,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls Help - blank cell/formula issue 7
Passed Arguments to a UDF 9
How do I shorten an IF formula? 4
IF function question 9
Creating one formula for use in two different cells 2
IF Formula with AND added (I think) 3
formula help 0
OR function problem 16

Top