View Single Post
  #5   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"?

<into three zones

Four, of course
Sorry about that

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| 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
||
||
||
|
|