Boolean expressions

B

Brad

How do I change the windows default from true/false to 1/0 (for boolean expressions)

I do realize that I can multiply the result by 1, but there has to be a setting that I can change.
 
F

Frank Kabel

Hi Brad
AFAIK there is no setting. You may use a custom format to display 1/0
but in all other cases simply convert the boolean expression by
multiplying with one or
=--boolean_expression
 
B

Bernard Liengme

I hate to contradict Frank but if you use Tools|Options and open the
Transitions tab you will see a box labelled Transition Formula Evaluation.
Check this and for your current sheet you will get 1 and 0 in place of TRUE
and FALSE.

Has to be done to all sheets in a workbook (I think you could group them and
do it once - try it)

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


Brad said:
How do I change the windows default from true/false to 1/0 (for boolean expressions)?

I do realize that I can multiply the result by 1, but there has to be a
Click to expand...
setting that I can change.
 
F

Frank Kabel

Hi Bernard
But he will change a lot more things with this option :)
Though I had to admit I've never used this option
 
D

Dave Peterson

One thing that I find difficult to track down:

In A1: ASDF
in B1: =if(a1=0,1,2)

Then toggle that setting and watch B1.

Lotus 123 treats text differently than excel.

(This is scary enough for me to stay away from that setting!)
 
Top