# question

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

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）

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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