software

I have an existing function that works.
=IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
$AJ$18).

I need to add to it that if AL18, AM18, and AM19 are N but if D5 is greater
than 10000 then quot;Call for Std Pricing Quotequot;. I need to show quot;Standard
Pricing if AL18, AM18, AN19, and D5lt;10000. If any of the AL18, AM18, AN18
are yes then $aJ$18.

I tried to add another IF statement but got a Value error.

Help.

Thanks

Michael

=IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;),quot;St andard Pricingquot;,
IF(OR(AL18=quot;Yquot;,AM18=quot;Yquot;,AN18=quot;Yquot;),$AJ$18,IF(D5gt;100 00,quot;Call for Std Pricing
Quotequot;,quot;STandard Pricingquot;)))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;THE BIG Oquot; gt; wrote in message
...
gt; I have an existing function that works.
gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
gt; $AJ$18).
gt;
gt; I need to add to it that if AL18, AM18, and AM19 are N but if D5 is
greater
gt; than 10000 then quot;Call for Std Pricing Quotequot;. I need to show quot;Standard
gt; Pricing if AL18, AM18, AN19, and D5lt;10000. If any of the AL18, AM18, AN18
gt; are yes then $aJ$18.
gt;
gt; I tried to add another IF statement but got a Value error.
gt;
gt; Help.
gt;
gt; Thanks
gt;
gt; Michael
Hmmm, that did not work. I put in 15000 in D5 and the result still shows
Standard pricing. I need to clarify something I said earlier, If any of
the AL18, AM18, and AN18 say N, then it is to give me $AJ$18. If all are yes
and then if D5 is over 10000 then quot;Call for Std Pricing , if all are Y
and D5 is less than 10000 then give me quot;Standard Pricingquot;.

Thanks for your help.

Michael
quot;Bob Phillipsquot; wrote:

gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;),quot;St andard Pricingquot;,
gt; IF(OR(AL18=quot;Yquot;,AM18=quot;Yquot;,AN18=quot;Yquot;),$AJ$18,IF(D5gt;100 00,quot;Call for Std Pricing
gt; Quotequot;,quot;STandard Pricingquot;)))
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;THE BIG Oquot; gt; wrote in message
gt; ...
gt; gt; I have an existing function that works.
gt; gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
gt; gt; $AJ$18).
gt; gt;
gt; gt; I need to add to it that if AL18, AM18, and AM19 are N but if D5 is
gt; greater
gt; gt; than 10000 then quot;Call for Std Pricing Quotequot;. I need to show quot;Standard
gt; gt; Pricing if AL18, AM18, AN19, and D5lt;10000. If any of the AL18, AM18, AN18
gt; gt; are yes then $aJ$18.
gt; gt;
gt; gt; I tried to add another IF statement but got a Value error.
gt; gt;
gt; gt; Help.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Michael
gt;
gt;
gt;

Are the only possible values Ys, Ns and a zero for AM18? If so,

=if(SUMPRODUCT(--(AL18:AN18=quot;Nquot;))gt;0,$AJ$18,IF(D5gt;10000,quot;Call for
quot;,quot;quot;)amp;quot;Standard Pricingquot;)
quot;THE BIG Oquot; wrote:

gt; Hmmm, that did not work. I put in 15000 in D5 and the result still shows
gt; Standard pricing. I need to clarify something I said earlier, If any of
gt; the AL18, AM18, and AN18 say N, then it is to give me $AJ$18. If all are yes
gt; and then if D5 is over 10000 then quot;Call for Std Pricing , if all are Y
gt; and D5 is less than 10000 then give me quot;Standard Pricingquot;.
gt;
gt; Thanks for your help.
gt;
gt; Michael
gt;
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;),quot;St andard Pricingquot;,
gt; gt; IF(OR(AL18=quot;Yquot;,AM18=quot;Yquot;,AN18=quot;Yquot;),$AJ$18,IF(D5gt;100 00,quot;Call for Std Pricing
gt; gt; Quotequot;,quot;STandard Pricingquot;)))
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;THE BIG Oquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have an existing function that works.
gt; gt; gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
gt; gt; gt; $AJ$18).
gt; gt; gt;
gt; gt; gt; I need to add to it that if AL18, AM18, and AM19 are N but if D5 is
gt; gt; greater
gt; gt; gt; than 10000 then quot;Call for Std Pricing Quotequot;. I need to show quot;Standard
gt; gt; gt; Pricing if AL18, AM18, AN19, and D5lt;10000. If any of the AL18, AM18, AN18
gt; gt; gt; are yes then $aJ$18.
gt; gt; gt;
gt; gt; gt; I tried to add another IF statement but got a Value error.
gt; gt; gt;
gt; gt; gt; Help.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; Michael
gt; gt;
gt; gt;
gt; gt;

After making a change to the second IF statement it worked. Before the
change I kept getting a False and realized that it was missing the answer to
give if the formula was false. I think this works. I am going to have
several of my office mates throw different scenarios against my spreadsheet
to make sure the answers are correct.

Thank you very much for your help.

Michael

quot;Duke Careyquot; wrote:

gt; Are the only possible values Ys, Ns and a zero for AM18? If so,
gt;
gt; =if(SUMPRODUCT(--(AL18:AN18=quot;Nquot;))gt;0,$AJ$18,IF(D5gt;10000,quot;Call for
gt; quot;,quot;quot;)amp;quot;Standard Pricingquot;)
gt;
gt;
gt;
gt; quot;THE BIG Oquot; wrote:
gt;
gt; gt; Hmmm, that did not work. I put in 15000 in D5 and the result still shows
gt; gt; Standard pricing. I need to clarify something I said earlier, If any of
gt; gt; the AL18, AM18, and AN18 say N, then it is to give me $AJ$18. If all are yes
gt; gt; and then if D5 is over 10000 then quot;Call for Std Pricing , if all are Y
gt; gt; and D5 is less than 10000 then give me quot;Standard Pricingquot;.
gt; gt;
gt; gt; Thanks for your help.
gt; gt;
gt; gt; Michael
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;),quot;St andard Pricingquot;,
gt; gt; gt; IF(OR(AL18=quot;Yquot;,AM18=quot;Yquot;,AN18=quot;Yquot;),$AJ$18,IF(D5gt;100 00,quot;Call for Std Pricing
gt; gt; gt; Quotequot;,quot;STandard Pricingquot;)))
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from the email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;THE BIG Oquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I have an existing function that works.
gt; gt; gt; gt; =IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
gt; gt; gt; gt; $AJ$18).
gt; gt; gt; gt;
gt; gt; gt; gt; I need to add to it that if AL18, AM18, and AM19 are N but if D5 is
gt; gt; gt; greater
gt; gt; gt; gt; than 10000 then quot;Call for Std Pricing Quotequot;. I need to show quot;Standard
gt; gt; gt; gt; Pricing if AL18, AM18, AN19, and D5lt;10000. If any of the AL18, AM18, AN18
gt; gt; gt; gt; are yes then $aJ$18.
gt; gt; gt; gt;
gt; gt; gt; gt; I tried to add another IF statement but got a Value error.
gt; gt; gt; gt;
gt; gt; gt; gt; Help.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; Michael
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;