There has been a few great examples in the forum that does this MUCH
more effectively, but I have always been doing it the long way, so here
goes:

=IF(AND(A1=50001, A1<=80000), A1*0.08, IF(AND(A1=30001, A1<=50000),
A1*0.1, IF(AND(A1=20001, A1<=30000), A1*0.12, IF(AND(A1=10001,
A1<=20000), A1*0.15, IF(AND(A1=5001, A1<=10000), A1*0.17,
IF(AND(A1=3000, A1<=5000), A1*0.2, "Out of Range"))))))


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554608