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.