multiple functions in a single cell

[John C.]

Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!

 

[Bernard Liengme]

=IF(G4=2,"Cathy's Check", if(G4=3,"John's Check" ,"")

This is display nothing if G4 is other than 2 or 3
If the list gets longer, a lookup function would be appropriate.
best wishes

 

[Gary''s Student]

Use an IF statement in G4:

=IF(B4=2,"Cathy's Check",IF(B4=3,"John'sCheck",""))

 

[Mike H]

Try this in G4

=CHOOSE(B4,"","Cathy's Check","John's check")

Mike