Nested FOR & AND Functions Error

[nwegman7878]

I am trying to complete an excel worksheet that completed pricing depending on various sizes, flavors, etc. In this particular instance the pricing is as follows:
Regular - 15ml $5.00
Black Flag - 15ml $6.00
Regular - 30ml $10.00
Black Flag - 30ml $12.00

This is what I understood to work and it seems to be glitching somewhere.

=IF(D17="15 ml"(AND(B17="Black Flag", "$6.00","5.00",IF(D17="30 ml"(AND(B17="Black Flag", "$12.00", "$10.00"))))))

Any help is greatly appreciated. Thanks!

[Tony Valko]

Try this...

=IF(D17="15 ml",IF(B17="Regular",5,IF(B17="Black Flag",6,"")),IF(D17="30 ml",IF(B17="Regular",10,IF(B17="Black Flag",12,"")),""))

Format the result as Currency, 2 decimal places.

[Vikas_Gautam]

You can try this as well..

Please Login or Register  to view this content.

Check the attached file...