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,