=IF(AND(AL18="Y",OR(AM18="Y",AM18=0),AN18="Y"),"St andard Pricing",
IF(OR(AL18="Y",AM18="Y",AN18="Y"),$AJ$18,IF(D5100 00,"Call for Std Pricing
Quote","STandard Pricing")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"THE BIG O" wrote in message
...
I have an existing function that works.
=IF(AND(AL18="Y",OR(AM18="Y",AM18=0),AN18="Y")=TRU E,"Standard Pricing",
$AJ$18).

I need to add to it that if AL18, AM18, and AM19 are N but if D5 is
greater
than 10000 then "Call for Std Pricing Quote". I need to show "Standard
Pricing if AL18, AM18, AN19, and D5<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