Try this in C1:

=IF(A1<=10000,"A",IF(A1<=50000,"B","C"))

HTH

Ian

"John" wrote:

I have a column that lists a percentage, and a colum that lists a dollar
amount. I want a column that will divide dollar amount ranges into groups.
See example below.

A1 = 10,000
B1 = 4.00%
C1 = A

So i want any dollar amount below 10,000 to be in group A. Anything from
10,001 - 50,000 into group B. 50,001 to 100,000 into group C. I dont know
if you use If stagements, or And statements or something else? Any help or
suggestions would be appreciated. Thanks