| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting TRUE/FALSE to 1/0
It's nice to use TRUEs and FALSEs in simple calculations (such as add and
multiply) where TRUE cells are treated by Excel as having a value of 1 and FALSE cells 0 - although it is strange that =SUM treats them all as 0. Does anyone know a way of formatting logical cells to actually display 1 for TRUE and 0 for FALSE? Obviously one could put together a macro or UDF that physically converted these values but I would ideally like some kind of Excel format. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Formatting TRUE as 1 and FALSE as 0 | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| True or False | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Threaded Mode
