EXCEL 2003 - Boolean conventions
"imfaizzi" wrote:
Is there a way to convert that text "TRUE" into digit "1"?
=--(A1A2)
returns 1 for TRUE and 0 for FALSE. Similarly for =1*(A1A2)
"imfaizzi" wrote in message
...
hi
Im performing Logical boolean operations using MS Excel. The only problem
is
that its displaying result set as "TRUE/FALSE" and I want to have the
result
in binary.
Is there a way to convert that text "TRUE" into digit "1"?
please tell me ASAP.
thank
|