LinkBack URL
About LinkBacks
Hello. Someone posted this formula =--(COUNTIF(D5:D8,1)>0) and said that the -- converts the boolean number to their number counterparts. How does this work?
Hello. Someone posted this formula =--(COUNTIF(D5:D8,1)>0) and said that the -- converts the boolean number to their number counterparts. How does this work?
A Boolean is either TRUE or FALSE.
For example
=A1=B1
will display TRUE if A1 equals B1; otherwise FALSE.
=--(A1=B1) is a Number and will display 1 if A1 equals B1; otherwise 0
Gary's Student
Boolean results are typically TRUE or FALSE. When -- is used, the results change to this:
TRUE = 1
FALSE = 0
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks