question

02539402 avatar image
0 Votes"
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）

not-supported
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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 avatar image
0 Votes"
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

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

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

Best regards,
Leon


· 1 · Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

02539402 avatar image 02539402 ·

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

0 Votes 0 · ·