Can I change the way truth values are displayed?

  • Thread starter Thread starter xirx
  • Start date Start date
X

xirx

Hi!

By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
there a way to change this? E.g., can I have just a e.g. an "x" instead of
"TRUE" and a "." only instead of "False"?

Of course, I could use formulas like...

A1=IF(<Condition>,"x";".")

....but this way, I'd have to use

A2=IF(A1="x"; ..., ...)

....instead of the more simple

A2=IF(A1; ..., ...)

So, can I change the way Excel displays truth values?

Ingolf.
 
If you start your formula with a =--(formula), then it will return a 1 for
true, 0 for false.

If you format your cells/custom

X;;O

it will show X when true, O when false

Beege
 
Nice workaround. Thank you very much!


Beege said:
If you start your formula with a =--(formula), then it will return a 1 for
true, 0 for false.

If you format your cells/custom

X;;O

it will show X when true, O when false

Beege
Click to expand...
 
Back
Top