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

  • Thread starter Thread starter gootroots
  • Start date Start date
G

gootroots

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

Much appreciate any help given.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get output of the formula instead of True or false 1
Formatting TRUE/FALSE to 1/0 11
Display values other than TRUE and FALSE 6
Excel VBA 1
Conditional Formatting Minimim Value 2
Custom Number Format for text 8
How to Format numbers from percentage points to basis points 1
XL 2003, True, False, 1, 0 8

Back
Top