Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function help needed
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function help needed
=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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function help needed
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 "Call for Std Pricing Quote:, if all are Y and D5 is less than 10000 then give me "Standard Pricing". Thanks for your help. Michael "Bob Phillips" wrote: =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function help needed
Are the only possible values Ys, Ns and a zero for AM18? If so,
=if(SUMPRODUCT(--(AL18:AN18="N"))0,$AJ$18,IF(D510000,"Call for ","")&"Standard Pricing") "THE BIG O" wrote: 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 "Call for Std Pricing Quote:, if all are Y and D5 is less than 10000 then give me "Standard Pricing". Thanks for your help. Michael "Bob Phillips" wrote: =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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, OR Function help needed
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 "Duke Carey" wrote: Are the only possible values Ys, Ns and a zero for AM18? If so, =if(SUMPRODUCT(--(AL18:AN18="N"))0,$AJ$18,IF(D510000,"Call for ","")&"Standard Pricing") "THE BIG O" wrote: 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 "Call for Std Pricing Quote:, if all are Y and D5 is less than 10000 then give me "Standard Pricing". Thanks for your help. Michael "Bob Phillips" wrote: =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed with function | Excel Worksheet Functions | |||
DAverage Function help needed | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
function needed | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions |