Grouping Percentages
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 |
Grouping Percentages
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 |
Grouping Percentages
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 |
Grouping Percentages
=IF(A1*B1<10001,"A",IF(A1*B1<50001,"B","C"))
-- Gary's Student "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 |
Grouping Percentages
Perfect. Thank you very much
"Ian P" wrote: 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 |
All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com