Hi JRinDallas
Try this:
=CHOOSE(1+(A120000)+(A140000),0,A1*0.1,(A1-40000)*0.15+4000)
Regards,
KL
"JRinDallas" wrote in message
...
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
|