One way... This way is nice becuase it easily expands if you need to add more
intervals or is you want to change the intervals...

=IF(A1<A4, 0, INDEX($C$4:$C$6, MATCH(A1, $A$4:$A$6, 1)))

Where the number to be evaluated is in A1 and the table of values as you
listed it is in A4:C6.
--
HTH...

Jim Thomlinson


"GEM" wrote:

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%