I need to produce a conditional sell price
dependant upont the cost price.
E.G. A10 Could contain a cost price between £2 and £500.
If the cost is between £2 - £20 I would like a cost price in A2 to be cost price plus 20%.
If the cost is between £20 - £100 I would like a cost price in A2 to be cost price plus 15%.
If the cost is between £100 - £500 I would like a cost price in A2 to be cost price plus 10%.
Whats the formula please ?
Thanks Ted
dependant upont the cost price.
E.G. A10 Could contain a cost price between £2 and £500.
If the cost is between £2 - £20 I would like a cost price in A2 to be cost price plus 20%.
If the cost is between £20 - £100 I would like a cost price in A2 to be cost price plus 15%.
If the cost is between £100 - £500 I would like a cost price in A2 to be cost price plus 10%.
Whats the formula please ?
Thanks Ted