It's quite possible. You will need to setup a lookup table correlating your
sales to a rating. For now, let's assume every 50 balls increases the rating
(up to 5).
In B1:C5

1.........1
51.......2
101.....3
151.....4
201.....5

Your formula then becomes:
=LOOKUP(A1,B1:C5)

Note that each value in the B column is the lower boundary of the section
that you want associated with that rating. Column B must be sorted in
ascending order.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Marty" wrote:

I want to be able to put a value in a cell A1 (aka # balls sold) and have A2,
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.