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）