Display TRUE / FALSE Instead Of 1 / 0
 

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Answer: Display TRUE / FALSE Instead Of 1 / 0
 

To display TRUE or FALSE instead of 1 or 0 in Excel:

1. Type your true/false formula in a cell. For example, let's say your formula is
   Code:

   ---

   =A1B1

   ---

   , which will return either TRUE or FALSE depending on whether the value in cell A1 is greater than the value in cell B1.
2. Click on the cell where you want the result to be displayed.
3. Type the following formula:
   Code:

   ---

   =IF(A1B1,"TRUE","FALSE")

   ---

   . This formula will check the result of your original formula (
   Code:

   ---

   A1B1

   ---

   ) and display the word "TRUE" if it's true, or "FALSE" if it's false.
4. Press Enter to see the result. You should now see either "TRUE" or "FALSE" displayed in the cell, depending on the result of your original formula.

Note that you can customize the text that's displayed by changing the words "TRUE" and "FALSE" in the formula to whatever you like. For example, you could use "Yes" and "No" instead.

Display TRUE / FALSE Instead Of 1 / 0
 

What's your formula look like?

Biff

"ExcelUser123" wrote in message
...
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

it depends on which logical formaula but here's one way.

=IF(AND(1<A2, A2<100), 1, 0)

"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

In article ,
ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Can you post the formula?

Display TRUE / FALSE Instead Of 1 / 0
 

hi exceluser

for an IF formula
maybe like this
=if(1=1,1,0) then replace it with
=if(1=1,TRUE,FALSE)

regards
--
*****
birds of the same feather flock together..



"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

Here is another way if your cell is either 1 or 0,

=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL"))


Hope it helps


Hank

"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

Remember that if you put "TRUE" and "FALSE" in quotes, they will be text
strings, not logical values.
--
David Biddulph

"Hank" wrote in message
...
Here is another way if your cell is either 1 or 0,

=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL"))

"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

As long as the formula truly results in a logical 1 or 0, then you can
create a custom format like:

"TRUE";;"FALSE";

positive #;negative #;zero;text

So for any non-zero number (which if the formula is truly a logical could
only be 1) the format will be "TRUE", nothing visible if it's negative,
"FALSE" if 0, and nothing if text...


"ExcelUser123" wrote in message
...
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Display TRUE / FALSE Instead Of 1 / 0
 

The formula is =D540 where D54 is a the NPV of an investment being evaluated
in a finance model across multiple years.

I understand how to write the IF statement to generate the text values of
"TRUE" or "FALSE".

I am trying to determine why this formula on my Desktop computer results in
a display of TRUE or FALSE (logical values not text) and on my Laptop
computer it results in a display of 1 or 0. Both machines are running
identical installations of Office 2003 in XP. I looked at display options,
formatting, styles, etc. but cannot find anything that explains the
difference.

Anyone have any ideas or similar experience?

"Domenic" wrote:

In article ,
ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

Can you post the formula?

Display TRUE / FALSE Instead Of 1 / 0
 

Toggle this setting:

Tools|Options|Transition tab
Uncheck "Transition formula evaluation"

You may find it better to uncheck all those lotus 123 settings.

ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

--

Dave Peterson

Display TRUE / FALSE Instead Of 1 / 0
 

That's a completely different question.........


"ExcelUser123" wrote in message
...
The formula is =D540 where D54 is a the NPV of an investment being
evaluated
in a finance model across multiple years.

I understand how to write the IF statement to generate the text values of
"TRUE" or "FALSE".

I am trying to determine why this formula on my Desktop computer results
in
a display of TRUE or FALSE (logical values not text) and on my Laptop
computer it results in a display of 1 or 0. Both machines are running
identical installations of Office 2003 in XP. I looked at display
options,
formatting, styles, etc. but cannot find anything that explains the
difference.

Anyone have any ideas or similar experience?

"Domenic" wrote:

In article ,
ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or
FALSE
instead of 1 or 0?

Can you post the formula?

Display TRUE / FALSE Instead Of 1 / 0
 

Thank you Dave. Updating that setting solved the problem.

"Dave Peterson" wrote:

Toggle this setting:

Tools|Options|Transition tab
Uncheck "Transition formula evaluation"

You may find it better to uncheck all those lotus 123 settings.

ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

--

Dave Peterson