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%

=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%

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%

"GEM" escreveu:

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%


IF(A120.01,9%*A1,IF(A110.01,8.25%*A1,IF(A10.01, 8%*A1,0)))

hth
--

pleae click yes if it was helpfull
regards from Brazil
Marcelo

=IF(A20,8%+(A210)*0.25%+(A220)*0.75%,"")

--
__________________________________
HTH

Bob

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

Another way; (easy to edit)

=LOOKUP(A1,{0,0.01,10.01,20.01},{0,0.8,0.825,0.9})

If this post helps click Yes
---------------
Jacob Skaria


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

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%

=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%