Maybe this would work:

In A1 type in "Revenue"
In B1(This will be used as a data entry field) type in the
revenue Say $20,000 for example

Then:
Create a table with 2 columns
column A would show bottom of revenue range

Column B would show the percentage of the revenue that
would flow to the producer

Example:
A B
5 Range Start Percent to Agent
6 $1000 .05
7 $2001 .07
8 $3501 .10
Etc.

Once you get the table built you can create a "lookup"
formula.

So for example in A12 you may type in "% of revenue due to
agent" just as a title.

And then in B12 create the lookup formula such as:
=lookup(a2,a6:a8,b6:b8)

This will look up the correct % to assess on the gross
revenue.

Then in A14 you could type in "$ amount due to agent"
Then in B14 you could enter formula such as:
= b1*b12

Hope this helps.


-----Original 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?
.