I don't know. I'm doing this for somebody in our office that's not here.
Actually, they need the formula to be as such:

If A1 is between: $3,000 - 5,000 then 20%; if $5,000 - 10,000 then 17%; if
$10,000 - 20,000 then 15%; if $20,000 - 30,000 then 12%, if $30,000 - 50,000
then 10%; if 50,000 - 80,000 then 8%.

Thanks!!!!

"tim m" wrote:

What do you want to appear if the number is not between those values? (In
Marcelos solution the result of A1 shows up and in Bearacades solution a
blank is put in the cell.)

"Sherry" wrote:

I think I need to use an "IF" function for the following but don't know how
to write if statements. Can anybody help?

If Cell A is between 3,000 and 5,000 then multiply by 20%

Thanks!!