Formula to Label Cells

[BigUps]

I have imported data from a church contributions program which
identifies funds by number. For example 1 = Tithes; 2 = Missions; 3 =
Building Fund, etc. These fund numbers appear in column B. I need a
formula to insert the actual fund names as labels in column B. As far
as I have gotten is an = IF(B3=1,"TITHES","MISSIONS"). This only
results in two lables Tithes and Missions when actually I have 5
different funds.

TMIA

 

[Gord Dibben]

=IF(B3=1,"tithes",IF(B3=2,"missions",IF(B3=3,"building")))

You can "nest" up to seven(7) of these.

Alternate........

=CHOOSE(B3,"tithes","missions","building","whatever")

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Thomas]

Another way, you list your labels in a column,say C1:C5 in the correct
order
=index(c1:c5,b1)

 

[CLR]

=IF(B3=1,"LABEL1",IF(B3=2,"LABEL2",IF(B3=3,"LABEL3",IF(B3=4,"LABEL4",IF(B3=5
,"LABEL5","")))))

This will also give you a blank cell if anything besides a 1,2,3,4,or 5 is
in B3......
If this formula comes through the post being wordwrapped make sure you put
it all in one cell on your sheet......

Vaya con Dios,
Chuck, CABGx3

 

[Thomas]

Or on second thought:
=index({"tithes","missions","buildings","missions","whatever"},b1)