formula based on criteria

[ciava01]

Hello,

I'm pretty new to excel, and can do most basic functions. However can any one help to see if a the following can be achieved?

I'm looking to use a sum formula based on certain condition. so For example I have 2 different customers who receive different discount. say customer 1 receives 10% and customer 2 receives 15%.

is there any formula which would allow having a separate discount based on name inputted in cell b?
A B C
Sales Price - Customer - discount -
1 - £10.00 - Customer 1 - In cell C is where I would have the formula to calculate - if cell b="customer1"Sales price*0.1, if cell b="customer2",Sales price*0.15

many thanks,

[NeedForExcel]

Here!

=A2*VLOOKUP(B2,{"Customer1",0.1;"Customer2",0.15},2,0)

Notice, I have hardcoded ranges.

I would normally store this in an Excel Table, and use that as my Vlookup Range

Customer1 10%
Customer2 15%

See the file attached..

[ciava01]

Fantastic. Many thanks for you swift help!!!

Much appreciated.http://www.excelforum.com/images/icons/icon7.png

[NeedForExcel]

Glad I could help!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.