Format a Logical Value?

  • Thread starter Thread starter Good Try
  • Start date Start date
G

Good Try

Is there any way to set a custom format for a cell that contains logical
values?

In other words, instead of displaying TRUE or FALSE, can these values be
formatted to display something else such as ON or OFF, or ELIGIBLE or
INELIGIBLE, while still retaining their logical values?
 
Not directly, but since XL interprets zero as FALSE and any other
numeric value as TRUE, you could use

Format/Cells/Number/Custom "ON";"ON";"OFF"

Then convert all your booleans to numbers. For instance:

=(A1>0)

to

=-(A1>0)

Or

=IF(A1>0, TRUE, FALSE)

to

=-IF(A1>0, TRUE, FALSE)

The values can still be used as if they were booleans.
 
Back
Top