try
=A1+LOOKUP(A1,{0,100,2001,5001,15001},{0.15,0.1,0. 07,0.05,0.04})*A1
or =A1*(1.04+LOOKUP(A1,{0,100,2001,5001},{0.11,0.06,0 .03,0.01}))

"Kat" wrote:

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!