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 =B1+1
.
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)