G gootroots Aug 14, 2009 #1 I want to convert cell values in a range to be displayed in boolean format. Much appreciate any help given.
I want to convert cell values in a range to be displayed in boolean format. Much appreciate any help given.
J Jacob Skaria Aug 14, 2009 #2 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
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 Aug 14, 2009 #3 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.
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.
