Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply various percentage with sales between a & b, b & c, etc.
I want the bonus percentage to change from zero to 1% with sales are between
$70,000 and $89,999.99 to 2% when between $90,000 and $119,999.99 to 4% when between $120,000 and $144,999.99 to 5% when between $145,000 and $174,999.99 to 7% when between $175,000 and $204,999.99 and 9% when between $205,000 and $5,000,000 The total sales cell is E4 and the Bonus Percentage cell is O5 Thanks for the help. -- Rick R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply a percentage factor to a base number | Excel Worksheet Functions | |||
Apply a percentage factor to a base number | Excel Worksheet Functions | |||
How do I apply icon sets to percentage values in Excel worksheet? | Excel Worksheet Functions | |||
Sales comparison percentage question | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions |