Array formula and AND

[PritiOne]

I need help with the following formula:

=IF(OR(DealType={3000,"3000Rx","3000 w/ Drawer Choice","3000Rx w/ Drawer Choice"}),IF(PromoPricing?="Crunch Time Promo",IF(VLOOKUP(S19,ProductTable,44,0)="Y",IF(K19="K",(P19+(P19*0.1)),IF(K19="U",(P19+(P19*0.2)))),VLOOKUP(S19,ProductTable,TERMCODE,)),VLOOKUP(S19,ProductTable,TERMCODE,0)),VLOOKUP(S19,ProductTable,TERMCODE,0))

Crteria to meet:

DealType, PromoPricing?, Vlookup resulting in "Y" then perform a ceratin calculation based on "K' or "U"

Else, vlookup(s19,producttable,termcode,false)

Can I use and AND statement for the first 3 conditions? Then, if met, do specific calculation?

If not, can I get help with the above formula, please.

 

[fairwinds]

Hi,

Try:

=IF(AND(OR(DealType={3000,"3000Rx","3000 w/ Drawer Choice","3000Rx w/ Drawer Choice"}),PromoPricing?="Crunch Time Promo",VLOOKUP(S19,ProductTable,44,0)="Y"),IF(K19="K",P19+P19*0.1,P19+P19*0.2),VLOOKUP(S19,ProductTable,TERMCODE,0))