Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Baseline Formula
Excel 2007
I am trying to get a formula to do the following commision; If A1 is less then or equal to $2,000.00 then B2 would equal 2% of that amount. If A1 is greater then $2,000.00 then B2 would equal 2% of the $2,000.00 plus 5% of the amount over the $2,000.00 baseline. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a 98% baseline across my chart? | Charts and Charting in Excel | |||
Baseline values for comparison | Charts and Charting in Excel | |||
Baseline | Charts and Charting in Excel | |||
Can I add a baseline value to a chart? | Charts and Charting in Excel | |||
Adding a Baseline Value into my existing column graph. | Excel Worksheet Functions |