Display TRUE / FALSE Instead Of 1 / 0

[Guest]

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

 

[T. Valko]

What's your formula look like?

Biff

 

[Guest]

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

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

 

[Domenic]

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?

 

[Guest]

hi exceluser

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

regards

 

[Guest]

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

 

[David Biddulph]

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

 

[Marc]

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...

 

[Guest]

The formula is =D54>0 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?

 

[Dave Peterson]

Toggle this setting:

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

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

 

[Marc]

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

The formula is =D54>0 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?

 

[Guest]

Thank you Dave. Updating that setting solved the problem.