EXCEL 2003 - Boolean conventions

[imfaizzi]

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

 

[JoeU2004]

Is there a way to convert that text "TRUE" into digit "1"?

=--(A1>A2)

returns 1 for TRUE and 0 for FALSE. Similarly for =1*(A1>A2)