How do I make 1 = "yes"?
There is this ancient Format feature where you can specify up to 3 conditions plus an Else branch.
FormatCellsNumber tab, Custom. In the Type box, enter something like
[=1]"yes";[=2]"Not enough info";"no"
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"lindasuenwh" wrote in message ...
|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
|