software

I have the following formula, which returns an unexpected answer

=IF(AND(G11=quot;Offquot;,G14gt;0),quot;Not Expected
Inquot;),IF(OR(F13=quot;quot;,F14=quot;quot;),quot;quot;,IF(AND(G12gt;0,G14lt;=0), quot;No
Showquot;,IF(ISERROR(IF((F13-F$7)gt;F11,quot;In Latequot;,quot;quot;)),quot;quot;,IF((F13-F$7)gt;F11,quot;In
Latequot;,quot;quot;))))

My Data contains the following

G11=Off
G14=contains a value gt;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 quot;Not Expected Inquot; as both
G11 and G14 conform to the first part of my formula.

The answer actually returned is quot;Blankquot;. Do I have a bracket missed out or
in the wrong place?

Thanks
Worked itquot;Johnquot; gt; wrote in message
...
gt;I have the following formula, which returns an unexpected answer
gt;
gt; =IF(AND(G11=quot;Offquot;,G14gt;0),quot;Not Expected
gt; Inquot;),IF(OR(F13=quot;quot;,F14=quot;quot;),quot;quot;,IF(AND(G12gt;0,G14lt;=0), quot;No
gt; Showquot;,IF(ISERROR(IF((F13-F$7)gt;F11,quot;In Latequot;,quot;quot;)),quot;quot;,IF((F13-F$7)gt;F11,quot;In
gt; Latequot;,quot;quot;))))
gt;
gt; My Data contains the following
gt;
gt; G11=Off
gt; G14=contains a value gt;0
gt; F13=contains a value
gt; F14=contains a value
gt; G12=0
gt; G14=is greater than Zero
gt; F7=contains a value
gt; F11=blank
gt;
gt; With my data above, I expect my formula to return quot;Not Expected Inquot; as
gt; both G11 and G14 conform to the first part of my formula.
gt;
gt; The answer actually returned is quot;Blankquot;. Do I have a bracket missed out or
gt; in the wrong place?
gt;
gt; Thanks
gt;
gt;