| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excell
Does anyone no how to set a formula to do this,
there is different ranges like 0-499,500-799,800-999 and with each range there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price falls into the range need the percentage like 303=3.03 or 805=24.15. thanks Mike |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excell
=LOOKUP(B1,{0,500,800,1000},{0.01,0.02,0.03})*B1
Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 11:28:15 -0800, americasmattress8888 wrote: Does anyone no how to set a formula to do this, there is different ranges like 0-499,500-799,800-999 and with each range there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price falls into the range need the percentage like 303=3.03 or 805=24.15. thanks Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| editing documents with excell that are not excell format | Excel Discussion (Misc queries) | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
| Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Hybrid Mode
