how do I format cells containing a value to display as true/false

G

gootroots

I want to convert cell values in a range to be displayed in boolean format.

Much appreciate any help given.
 
J

Jacob Skaria

Select the cells. Right click> Format cells> Custom>Type: the below and hit OK

+ve values will be displayed as TRUE
-ve values will be displayed as FALSE
0 will be displayed as 0 itself

"TRUE";"FALSE";"0"

If this post helps click Yes
 
D

David Biddulph

If the limits of your range of values are A1 and B1, and your data item is
in A2
=MEDIAN(A$1,B$1,A2)=A2 will be TRUE is A2 is within the range, and FALSE if
not.
 
Top