Kevin,

Try a lookup table for the % that you want. (See help on vlookup)

=VLOOKUP(B2,$D$1:$E$5,2,TRUE)
where B2 is the revenue. $D$1:$E$5 is the range containing your table.
2 represents the column to extract. True says to find the closest match.
(I suggest you use the decimal percent in my 3rd column)

The table can be on a different sheet. If so change $D$1:$E$5 to
Sheet2!$D$1:$E$5 (change Sheet2 to the sheet name)

Set up your table for the minimum in each range
Revenue Percentage
1 5.5 (0.055)
20001 7.0 (0.007)
etc

= B2*VLOOKUP(B2,$D$1:$E$5,2,TRUE)
--
sb
"Kevin Vidrine" wrote in message
...
What Im trying to do i make a spreadsheet to calculate
commission for our salesman. The way it work is they get a
percentage of the revenue they bring in. For instance, if
their revenue is between $1 and $20000, they get 5.5% of
the revenue. Between 20 and 25K is 7% and so on. There is
14 different percentages that could be used depending on
what the revenue is. I want to write a formula that takes
the input which would be revenue, and multiplies it by the
correct percentage. I have tried to do this by using an if
statement but I can't get the if statement to work when
telling it if the revenue is between two numbers, such as
between 20 and 25 thousand. What other formulas will work?