Result between two numbers
I need a formula to return a percentage if spend is between two figures. e.g.
if spend is between £10,000 and £20,000 I need the formula to return the
percentage discount for this spend, likewise if it is between £20,000 and
£30,000 the discount will be different.
The discounts are held on the spreadsheet so I just need the formula to link
to this and return the appropriate discount %.
Any ideas?
|