=IF function help

[Bandicoot]

Hi all,

I’m trying to create some tools that will help me cut down on my manual calculations.

I’ve attached a mock template of what I’m trying to achieve.

I have a list of customers, some of whom are eligible for a discount, whether that be a % discount, or a £ discount. This is shown on sheet 2. A customer will never be eligible for both, it will be one or the other, or in some cases, no discount at all.

What I would like, is to select a customer, if they are eligible for a % discount then the Total amount in B8 will work out Total cost minus the % value. If another customer is selected that has a £ discount, then B8 will be Total cost minus the £ discount. Finally, if the customer has no discount at all, then the total cost is just displayed in B8.

Thank you.

[Pete_UK]

First of all, for Customer F in row 7 of Sheet2, leave both cells B7 and C7 empty to indicate no discount. Then you can have this formula in B8 of Sheet1:

=B5*(1-B2)-B3

Hope this helps.

Pete

[Bandicoot]

Thank you Pete, that is such a simple way to do it!

[Pete_UK]

Ah well, keep it simple - easier to understand and maintain.

Pete