Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Assign one number to a number range
For example,
-assign 1 to any number between 50 and 64 -assign 2 to any number betwen 65 to 79 -assign 3 to any number between 80-100 So that 62 (in column 1) will be coded as a 1 (in column 2), whereas 67 would be coded a 2 and 83 would be coded a 3. |
#2
|
|||
|
|||
In cell B1 put this formula and copy down..........
=IF(OR(A1<50,A1100),"Out of range",IF(A1=80,3,IF(A1=65,2,IF(A1=50,1)))) Vaya con Dios, Chuck, CABGx3 "Sue" wrote in message ... For example, -assign 1 to any number between 50 and 64 -assign 2 to any number betwen 65 to 79 -assign 3 to any number between 80-100 So that 62 (in column 1) will be coded as a 1 (in column 2), whereas 67 would be coded a 2 and 83 would be coded a 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I assign a text value to a variable number of rows? | Excel Worksheet Functions | |||
How can I assign a number value to a letter grade in Excel? | Excel Worksheet Functions | |||
Select same range from large number of workbooks | Excel Worksheet Functions | |||
How to add one number to a range of numbers | Excel Worksheet Functions |