In the formula calculation of Excel, how are logical (or boolean) values taken into computation?

Question

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）

Answer 1

Hi,

Q&A currently supports the products listed in right-hand pane (more to be added later on)

You can reach the experts in the dedicated Microsoft Excel forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?forum=excel

or
https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat

(please don't forget to mark helpful replies as answer)

Best regards,
Leon