M

#### Marty

aka (ball sales rating) convert it based on the following criteria to a

preset "rating". EX: I sell red balls. I have goals set in place based on

the number of balls I sell and the ratings are based on a 1 through 5 scale

(i.e 1-50 balls is a 1 rating, 60-100 balls is a 2 rating and so on). The

actual scales are difficult to remember and there are several of them hence

the need to simplify the way I am trying to do.

So, what I would like to do is to be able to key in a1 that I sold, say 10

balls and have a2 take this number, match it against the pre-filled scales

and place the correct sales rating in cell a2. I'm thinking this might fall

under an if - then (if a1 is 1-50, a2 will return the result 1) function but

can't seem to figure it out. Am I on the right track at all? Is this even

possible? Thanks in advance if anyone can provide some assistance and get me

going in the right direction.