Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bonus Calculation problem
The bonus amount will be 10% of any money collected over $20,000 up to
$40,000 and 15% of any money collected over $40,000. Ex: $52,000 collected in one month would produce a bonus of $3800 (10%*20,000=$2,000)plus(15%*$2,000=$1800). This formula calculates properly when the total money collect (E9) is greater than 40K but returns 2000 for everything below that =IF(OR(E920000,E9<=40000),((E9-(E9-20000))*0.1),0) Changing the OR to AND produces the correct results for less than 40 but zero for everything above that amount =IF(AND(20000<E9,E9<=40000),((E9-20000)*0.1),0) Any suggestions would be greatly appreciated. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time problem, Auto calculation??? | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |