Urgent Request. please help
Hello
This is kind of urgent, as I have this request from my manager. What I have is a excel sheet with numbers raning from $1 to $million dollars. and we have to bucket them up and label them A, B , C ..... ex.. Range 1-- any $ amount between (1 and 10,000)--is A. Range 2-- any $ amount between (10,000 and 100,000)--is B. Range 3-- any $ amount between (100,000 and 1million)--is C Range 4-- any $ amount between (1million and 5million)--is D Range 5-- any $ amount over 5million--is E. Can you please help me with this. I tried using the help section, but wan't able to find any useful info. Thanks a lot for your help. |
Urgent Request. please help
Is this what you're looking for?
=IF(A1<10000,"A",IF(A1<100000,"B",IF(A1<1000000,"C ",IF(A1<5000000,"D","E")))) This assumes your range of numbers starts in A1. Enter into an adjacent column, then copy down as needed. HTH, Elkar "pooja" wrote: Hello This is kind of urgent, as I have this request from my manager. What I have is a excel sheet with numbers raning from $1 to $million dollars. and we have to bucket them up and label them A, B , C ..... ex.. Range 1-- any $ amount between (1 and 10,000)--is A. Range 2-- any $ amount between (10,000 and 100,000)--is B. Range 3-- any $ amount between (100,000 and 1million)--is C Range 4-- any $ amount between (1million and 5million)--is D Range 5-- any $ amount over 5million--is E. Can you please help me with this. I tried using the help section, but wan't able to find any useful info. Thanks a lot for your help. |
Urgent Request. please help
AN easy way is to use The IF associated with AND Function (in excel 2003 you
can use 7 nested if functions, though you only need 5 of them). For an example look for the AND function in the HELP section and for nested IF functions. "pooja" wrote: Hello This is kind of urgent, as I have this request from my manager. What I have is a excel sheet with numbers raning from $1 to $million dollars. and we have to bucket them up and label them A, B , C ..... ex.. Range 1-- any $ amount between (1 and 10,000)--is A. Range 2-- any $ amount between (10,000 and 100,000)--is B. Range 3-- any $ amount between (100,000 and 1million)--is C Range 4-- any $ amount between (1million and 5million)--is D Range 5-- any $ amount over 5million--is E. Can you please help me with this. I tried using the help section, but wan't able to find any useful info. Thanks a lot for your help. |
Urgent Request. please help
Thanks for your help...
i used the IF function with and function..and it worked....once again thanks for your help. "andreA" wrote: AN easy way is to use The IF associated with AND Function (in excel 2003 you can use 7 nested if functions, though you only need 5 of them). For an example look for the AND function in the HELP section and for nested IF functions. "pooja" wrote: Hello This is kind of urgent, as I have this request from my manager. What I have is a excel sheet with numbers raning from $1 to $million dollars. and we have to bucket them up and label them A, B , C ..... ex.. Range 1-- any $ amount between (1 and 10,000)--is A. Range 2-- any $ amount between (10,000 and 100,000)--is B. Range 3-- any $ amount between (100,000 and 1million)--is C Range 4-- any $ amount between (1million and 5million)--is D Range 5-- any $ amount over 5million--is E. Can you please help me with this. I tried using the help section, but wan't able to find any useful info. Thanks a lot for your help. |
All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com