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?