| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells showing numbers other than the calculation result | Excel Discussion (Misc queries) | |||
| Format Result of a Formula Combining Text & Numbers | Excel Discussion (Misc queries) | |||
| Sorting Cells on letters and numbers and placing result in one of 3 columns | Excel Worksheet Functions | |||
| How do I convert formula result into numbers so I can sum results? | Excel Discussion (Misc queries) | |||
| select numbers from a list and add to optimise result | Excel Worksheet Functions | |||
Threaded Mode
