Maybe this:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

HTH,
Paul

"Kat" wrote in message
...
Hello,
Would I be able to create a if than statement for the following example.

If total is 0-99 than add 15
if total is 100-2000 than add 10%
if total is 2001-5000 than add 7%
if total is 5001-15000 than add 5%
if total is over 15000 than add 4%

Thanks!