Say I have the following table (with cells A1 & A2 merged together to have the common value of
| Col A | Col B | Col C | |-------|-------|--------| 1| 500 | 100 | =A1+B1 | 2| | 200 | =A2+B2 |
The Value of C1 is correctly populated to
600 while the value of C2 is populated as
200 instead of the expected
700. This is because even though the cell A2 is merged with A1 which has a value of
500, the reference to A2 returns
Is there any way I reference the value of the merged cell in a formula?
For instance, is there a formula that when passed a cell reference
A2 returns either the value of
A1 or tells me that
A2 has been merged with a top left location of
Are there any workarounds which are more practical than copying and pasting (and then keeping in sync) the values of A1 and A2?