| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Boolean comparison: range vs. single cell
msimms wrote...
.... but how does a TRUE or FALSE result get translated into a NUMERIC VALUE? .... Boolean (TRUE/FALSE) values used as operands to arithmetic operators are automatically converted into 1s for TRUE and 0s for FALSE. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Shading a range based on a single cell value. | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Threaded Mode
