| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a sliding scale discount
Hi,
I am trying to work out a formula for creating a sliding scale discount. I'm trying to create a pricing calculator spreadsheet for a printing company. If you buy 1 -5 copies the price is X, 6-20 copies the price is Y, 21-50 copies the price is W and so on. What is the best way of entering a number and returning the relevant discount amount? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a sliding scale discount
=IF(A1="","",LOOKUP(A1,{1,6,21,51},{"X","Y","W","Z "}))
"JonathanW" wrote: Hi, I am trying to work out a formula for creating a sliding scale discount. I'm trying to create a pricing calculator spreadsheet for a printing company. If you buy 1 -5 copies the price is X, 6-20 copies the price is Y, 21-50 copies the price is W and so on. What is the best way of entering a number and returning the relevant discount amount? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Sliding Scale Calculation | New Users to Excel | |||
| Calculating a sliding scale | Excel Worksheet Functions | |||
| Sliding Scale Percentage via IF? | New Users to Excel | |||
| Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) | |||
| calculating commission on sliding scale | New Users to Excel | |||
Linear Mode
