Forum Discussion
warrevar
Mar 04, 2019Brass Contributor
Formulas and Merging Cells
Hi Excel Community! I have a spreadsheet that requires me to occassionally merge cells WITHOUT it impacting a formula that references these cells. Currently, if I merge two or more cells in a co...
warrevar
Mar 05, 2019Brass Contributor
Are there any formulas you can use (some sort of 'IF' statement, I'd guess) that can account for if a cell is merged or not?
SergeiBaklan
Mar 05, 2019Diamond Contributor
The answer is here https://stackoverflow.com/questions/34788096/is-it-possible-to-test-return-if-a-cell-is-merged-without-vba