Display definition of a value in cell: 1 = F/T, 2 = P/T, etc

M

mike

I have a worksheet with imported data. I want to display the verbal
description for the numeric value in a field. Ex: 1 = F/T, 2 = P/T I would
rather see F/T in the field instead of 1. I hope this makes some
sense..............
 
K

Kevin Lehrbass

Hi Mike

If your numbers are in column A, then put this formula in column B:
=IF(A1=1,"F/T",IF(A1=2,"P/T",""))
Did you only have two different entries (F/T & P/T) ??

Cheers,
 
S

Sloth

you can use a custom format like

[=1]"F/T";[=2]"P/T"

this will display F/T instead of 1, P/T isntead of 2, all other numbers are
displayed normally. The cell value won't change, only the output of the cell.

Or you can do a find and replace to actually replace the 1's with F/T and
2's with P/T. If these aren't what you want please explain differently, and
I will try and help you more.
 
Top