K
KevL
Hi, I am trying to right a formulae for the following below: I think that I
should be using the IF but can't seem to make it work.
In my cell I will have a price of a part I want it to calculate the on cost
price to the customer using the table below:
<£5.00 = £5.00
<£10 +35% =
Example:
£5.00 = £6.75
£15.00 = £19.50
should be using the IF but can't seem to make it work.
In my cell I will have a price of a part I want it to calculate the on cost
price to the customer using the table below:
<£5.00 = £5.00
<£10 +35% =
10 <50 +30% =
50 <100 +25% =
100 <150 +20% =
150 <200 +15% =
Example:
£5.00 = £6.75
£15.00 = £19.50