Number to Word

8

8675039

I want to enter "1" in cell a1 and i want "annual" to populate into b1.
Iwant to enter ".52" in cell a1 and i want "semi-annual to populat
into b1.
so on and so on.

I want excel setup up so if i type 1 that it puts annual into a cell
Annual, semi annual, quarterly and monthly.

Is this possible??

Thanks
 
F

Frank Kabel

Hi
try the following:
in a separate sheet (e.g. called 'lookup') enter the following:
A B
1 0 monthly
2 0.25 quarterly
3 0.5 semi-anually
4 1.0 annual

Now use the following formnula on your second sheet
=VLOOKUP(A1,'lookup'A1:B5,2,TRUE)
 
Top