Given a simple spreadsheet, the cell A1 has a numeric value 1, and the cell B1 has a formula =A1>0, so its result is a logical value
TRUE. Also, the cell C1 has a formula
=SUM(B1,1) and the cell D1 has a formula
My question is that why the calculation result of C1 is 1, while that of D1 is 2? How the logical values taken into the
SUM function calculation and simple addition calculation? Why does this inconsistency happen?
Could anyone help me? Thanks very much! :)
P.S. My Excel version: Microsoft Excel for Mac 16.35 (20030802）