=IF(A115000,1.04,IF(A15000,1.05,IF(A12000,1.07, IF(A1100,1.1,1.15))))*A1
You could replace A1 by, for example, SUM(B2:B20)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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!