Hmm ...!? (1 explanation "F1" is "F2", and the second description "= 4" is an error of "= 2")
It has become a hot topic if the Excel seat and its cause, which will be a mysterious answer "1 + 1 = 4", are too difficult.If you think this is what ... you again!Cell bond![Image] People who want to destroy the cell bonds are Fujita who posted this tweet.When the combined cell is entered and "1" is entered into a single cell, and the case that is correctly "2" and the wrong answer returned to "4" are arranged.The reason why the wrong answer returns is that "1" is copied from a single cell and "paste it as a formula" into the binding cell.In this case, "1" is stuck on all the combined cells, and it looks "1 + 1" but actually "1 + 1 + 1 + 1".On the other hand, if "1" is normally entered into the binding cell, the invisible number is not entered, and it is calculated in "1 + 0 (blank) +0 (blank) +1".This is ... I don't know!There seemed to be many people who had been crying by the bond of cells, and many voices said, "The bond of the cell is evil" and "If the cell binding is destroyed ...".Cell binding is not always useless because it is a useful function in some cases, but it seems that you need to be careful.Image provision: Fujita -san
Netorabo