| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to work out 3 different %
I am stuck here trying to slove how I would work out 3 different discounts
one is the order is over 250 the discount is 15% two is the order is over 200 the discount is 10% three is the order is over 150 the discount is 5% I was wonder if anyone could please help me come up with a formula |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to work out 3 different %
Sam,
With your order amount in A1, this returns the discount % =LOOKUP(A1,{0,151,201,251},{0,0.05,0.1,0.15}) Mike "Sam" wrote: I am stuck here trying to slove how I would work out 3 different discounts one is the order is over 250 the discount is 15% two is the order is over 200 the discount is 10% three is the order is over 150 the discount is 5% I was wonder if anyone could please help me come up with a formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Linear Mode
