If then help

T

TimmerSuds

I have a column with the following text entries:

in process
production
inspection

There are several thousand records

I would like to be able to create an if/then formula and apply it t
the entire column that makes the following changes:

if "in process" then "01"
if "production" then "02"
if "inspection" then "03"

Can this be done?

Thanks
 
S

starguy

try the following formula.

I supposed that your data starts from cell A1, you can change referenc
according to your requirement.

=IF(A1="i
process","01",IF(A1="production","02",IF(A1="inspection","03"))
 
T

TimmerSuds

starguy said:
try the following formula.

I supposed that your data starts from cell A1, you can change reference
according to your requirement.

=IF(A1="in
process","01",IF(A1="production","02",IF(A1="inspection","03")))
Click to expand...


How would I apply this to an existibg column of records?
Thanks
 
D

Dave Peterson

Insert a new column to the right of the original data
Type that formula in the first cell
and drag down the range.

Excel will adjust the range in the copied cells.
 
Top