trying to code numbers in a cell

dterry

New Member
Joined
Nov 17, 2005
Messages
1
-I am trying to put in place a frmula that will assign a code number to a range of numbers. EX. If a number in AF3# is 97-100, I want Cell AG3 to display 1, If the number is 93-96 I want it to display 2, etc Any easy way to do that?

Thanx :rolleyes:
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
Why not set up a master list of the numbers and the corresponding "code numbers" and write a Vlookup formula.

Can two different "code numbers" be assigned to the same number i.e 97-100 = 1 and 97-100 = 2?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,908
Messages
5,574,959
Members
412,630
Latest member
Eireangel
Top