View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Luke Luke is offline
external usenet poster
 
Posts: 142
Default 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?