Well...probably better this way now that I think about it..

=MAX(0,A1*0.1-2000,A1*0.15-4000)

--
Dana DeLouis
Win XP & Office 2003


"Dana DeLouis" wrote in message
...
How about:

=MAX(0,(A1-20000)/10,(3*A1-80000)/20)

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"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