# question

02539402 asked ·

## 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.

### 1 Answer

LeonLaude answered ·

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

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

Best regards,
Leon

· 1 ·

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

Sorry for my carelessness. I will ask for help in the site you suggested. Thanks!

0 Votes 0 ·