This will take care of it.

=IF(AND(A35=20000,A35<=40000),(A35-20000)*0.1,IF(A35=40000,(A35-40000)*0.15+2000,""))

where "A35" equals reference to money collected.

Since I will need help with a problem in a minute, I figured I would
take some time to answer someone elses. Hopefully someone will return
the favor!


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=387502