| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel produce text in a given cell as a result of a boolean operation? | Excel Discussion (Misc queries) | |||
| In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
| Are there Boolean operators in MS Excel? | Excel Discussion (Misc queries) | |||
| File naming conventions | Excel Discussion (Misc queries) | |||
| boolean find criteria in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
