One method...........

=LOOKUP(B1,{0,100,2001,5001,15000},{1.15,1.1,1.07, 1.05,1.04})*B1


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 12:32:04 -0700, 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!