multiple functions in a single cell
 

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!

multiple functions in a single cell
 

=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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John C." <John wrote in message
...
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!

multiple functions in a single cell
 

Use an IF statement in G4:

=IF(B4=2,"Cathy's Check",IF(B4=3,"John'sCheck",""))
--
Gary''s Student - gsnu200773


"John C." wrote:

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!

multiple functions in a single cell
 

Try this in G4

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

Mike

"John C." wrote:

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!