How do I make 1 = "yes"?
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
|