=MIN(A2,25)*8.75%+MAX(0,A2-25)*3.5%+MAX(0,A2-1000)*1.5%

--
__________________________________
HTH

Bob

"GEM" wrote in message
...
Thank you this works great, now this is what I really need...

$0.01 - $25.00 --- 8.75% of the closing value

$25.01- $1,000.00 --- 8.75% of the initial $25.00, plus 3.50% of the
remaining closing value balance

Equal to or Over $1000.01 ---- 8.75% of the initial $25.00, plus 3.50% of
the initial $25.01 - $1,000.00, plus 1.50% of the remaining closing value
balance


"Bob Umlas" wrote:

=IF(A1<=10,8%,if(A1<=20,8.25%,9%))

"GEM" wrote in message
...
How can I use an IF function and tell excel that if a number is between
a
range, use a certain percentage and if it's between another range, use
another percentage.

For example.

Between 0.01 - 10.00 use 8%
Between 10.01 - 20.00 use 8.25%
Between 20.01 - infinite use 9%