software

Hi. For some reason when quot;K1232-L1232;M1232-K1232quot; is equal to the threshold,
the formula does not return quot;checkquot;. For example in:

IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25). In this case, if I1232
does not equal quot;sellquot; and M1232-K1232 equals -.25 the formula does not return
quot;checkquot;.

Here's the entire formula:

=IF(OR(AND(K1232lt;2;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25);AND(K1232gt;=2;K1232lt;=5;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.4);AND(K1232gt;5;K1232lt;=10;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.5);AND(K1232gt;10;K1232lt;=20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.8);AND(K1232gt;20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-1)); quot;Checkquot;;quot;quot;)

Thank you in advance.

Try rounding, i.e.,

IF(I1232=quot;sellquot;,round(K1232-L1232),round(M1232-K1232))lt;=-0.25)quot;carlquot; wrote:

gt; Hi. For some reason when quot;K1232-L1232;M1232-K1232quot; is equal to the threshold,
gt; the formula does not return quot;checkquot;. For example in:
gt;
gt; IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25). In this case, if I1232
gt; does not equal quot;sellquot; and M1232-K1232 equals -.25 the formula does not return
gt; quot;checkquot;.
gt;
gt; Here's the entire formula:
gt;
gt; =IF(OR(AND(K1232lt;2;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25);AND(K1232gt;=2;K1232lt;=5;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.4);AND(K1232gt;5;K1232lt;=10;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.5);AND(K1232gt;10;K1232lt;=20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.8);AND(K1232gt;20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-1)); quot;Checkquot;;quot;quot;)
gt;
gt; Thank you in advance.

I think Duke means

IF(I1232=quot;sellquot;,round(K1232-L1232,0),round(M1232-K1232,0))lt;=-0.25)--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Duke Careyquot; gt; wrote in message
...
gt; Try rounding, i.e.,
gt;
gt; IF(I1232=quot;sellquot;,round(K1232-L1232),round(M1232-K1232))lt;=-0.25)
gt;
gt;
gt; quot;carlquot; wrote:
gt;
gt; gt; Hi. For some reason when quot;K1232-L1232;M1232-K1232quot; is equal to the
threshold,
gt; gt; the formula does not return quot;checkquot;. For example in:
gt; gt;
gt; gt; IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25). In this case, if I1232
gt; gt; does not equal quot;sellquot; and M1232-K1232 equals -.25 the formula does not
return
gt; gt; quot;checkquot;.
gt; gt;
gt; gt; Here's the entire formula:
gt; gt;
gt; gt;
=IF(OR(AND(K1232lt;2;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25);AND(K123
2gt;=2;K1232lt;=5;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.4);AND(K1232gt;5;K1
232lt;=10;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.5);AND(K1232gt;10;K1232lt;=
20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.8);AND(K1232gt;20;IF(I1232=quot;se
llquot;;K1232-L1232;M1232-K1232)lt;=-1)); quot;Checkquot;;quot;quot;)
gt; gt;
gt; gt; Thank you in advance.
I have to correct Bob's correction or my error

IF(I1232=quot;sellquot;,round(K1232-L1232,2),round(M1232-K1232,2))lt;=-0.25)

I hope we're all done with this subjectquot;Bob Phillipsquot; wrote:

gt; I think Duke means
gt;
gt; IF(I1232=quot;sellquot;,round(K1232-L1232,0),round(M1232-K1232,0))lt;=-0.25)
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Duke Careyquot; gt; wrote in message
gt; ...
gt; gt; Try rounding, i.e.,
gt; gt;
gt; gt; IF(I1232=quot;sellquot;,round(K1232-L1232),round(M1232-K1232))lt;=-0.25)
gt; gt;
gt; gt;
gt; gt; quot;carlquot; wrote:
gt; gt;
gt; gt; gt; Hi. For some reason when quot;K1232-L1232;M1232-K1232quot; is equal to the
gt; threshold,
gt; gt; gt; the formula does not return quot;checkquot;. For example in:
gt; gt; gt;
gt; gt; gt; IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25). In this case, if I1232
gt; gt; gt; does not equal quot;sellquot; and M1232-K1232 equals -.25 the formula does not
gt; return
gt; gt; gt; quot;checkquot;.
gt; gt; gt;
gt; gt; gt; Here's the entire formula:
gt; gt; gt;
gt; gt; gt;
gt; =IF(OR(AND(K1232lt;2;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25);AND(K123
gt; 2gt;=2;K1232lt;=5;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.4);AND(K1232gt;5;K1
gt; 232lt;=10;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.5);AND(K1232gt;10;K1232lt;=
gt; 20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.8);AND(K1232gt;20;IF(I1232=quot;se
gt; llquot;;K1232-L1232;M1232-K1232)lt;=-1)); quot;Checkquot;;quot;quot;)
gt; gt; gt;
gt; gt; gt; Thank you in advance.
gt;
gt;
gt;

OK, I wasn't done:

shorter version:

ROUND(IF(I1232=quot;sellquot;,K1232-L1232,M1232-K1232),2)lt;=-0.25quot;Duke Careyquot; wrote:

gt; I have to correct Bob's correction or my error
gt;
gt; IF(I1232=quot;sellquot;,round(K1232-L1232,2),round(M1232-K1232,2))lt;=-0.25)
gt;
gt; I hope we're all done with this subject
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; I think Duke means
gt; gt;
gt; gt; IF(I1232=quot;sellquot;,round(K1232-L1232,0),round(M1232-K1232,0))lt;=-0.25)
gt; gt;
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Duke Careyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Try rounding, i.e.,
gt; gt; gt;
gt; gt; gt; IF(I1232=quot;sellquot;,round(K1232-L1232),round(M1232-K1232))lt;=-0.25)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;carlquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi. For some reason when quot;K1232-L1232;M1232-K1232quot; is equal to the
gt; gt; threshold,
gt; gt; gt; gt; the formula does not return quot;checkquot;. For example in:
gt; gt; gt; gt;
gt; gt; gt; gt; IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25). In this case, if I1232
gt; gt; gt; gt; does not equal quot;sellquot; and M1232-K1232 equals -.25 the formula does not
gt; gt; return
gt; gt; gt; gt; quot;checkquot;.
gt; gt; gt; gt;
gt; gt; gt; gt; Here's the entire formula:
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; =IF(OR(AND(K1232lt;2;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.25);AND(K123
gt; gt; 2gt;=2;K1232lt;=5;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.4);AND(K1232gt;5;K1
gt; gt; 232lt;=10;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.5);AND(K1232gt;10;K1232lt;=
gt; gt; 20;IF(I1232=quot;sellquot;;K1232-L1232;M1232-K1232)lt;=-0.8);AND(K1232gt;20;IF(I1232=quot;se
gt; gt; llquot;;K1232-L1232;M1232-K1232)lt;=-1)); quot;Checkquot;;quot;quot;)
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you in advance.
gt; gt;
gt; gt;
gt; gt;