Does the grouping have anything to do with any math with Column B?

Is it just "labeling" the value in Column A?

And what do you want to happen with values greater then 100,000?

Here's just one interpretation:

=IF(A1,IF(A150000,"C",IF(A110000,"B","A")),"No Data")

If this doesn't satisfy your needs, post back with additional info.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John" wrote in message
...
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