View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default 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.