Urgent Request. please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks for your help...
i used the IF function with and function..and it worked....once again thanks
for your help.
 
Back
Top