View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do I make 1 = "yes"?

Hi Chuck,

Not that I know of, at least not with 3 other conditions.
Normally the format code is divided into three zones: one each for positive, negative, zero, text.
But if you use it for self-defined conditions, I have not found a way to have 3 conditions and an ELSE branch.

Maybe someone else?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CLR" wrote in message ...
| That's very cool Nick, and certainly a keeper. It does exactly what the OP
| asks for, however, it will also return a "no" for any other number besides 0,
| 1, or2 in my XL97. Is there a way to change it to allow the other numbers to
| show as typed?
|
| Vaya con Dios,
| Chuck, CABGx3
|
|
|
| "Niek Otten" wrote:
|
| 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
|
|
|