EXCEL 2003 - Boolean conventions
 

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

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