Lindasuenwh,
Try this:
your resonse in cell C5, the formula in D5.
Answer
1 "IF($C$5=1,"YES",IF($C$5=2,"Not enogh info","NO"))

In the above example:
1 = YES, 2 = Not enough info, any other answer=NO
hth
Good luck :-)
"lindasuenwh" wrote:

I have looked all over and have to finish this report asap. Help is not
helping. How do I format a cell to return a word when I input a number? For
example, "2" = "Not enough info" or "0" = "No"?
Thanks -
Excel newbie