"~RobW" wrote:

....
=IF(CheckBox2,1,0)
....
NOTE: Depending on the version of Excel, 1 or 0 may show up in the cell or
TRUE or FALSE respectively may show up. When performing arithmetic
calculations, like addition, TRUE represents the number 1 and FALSE
represents the number 0.

In what version of Excel would this return a boolean? In my Experience,
Excel is quite careful about returning the requested type; though it will
coerce TRUE to 1 and FALSE to 0 if you then ask it to do math with them.

Jerry