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.

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.

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.

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.