Forum Discussion
Jga-123456
Feb 04, 2022Copper Contributor
Formula Error Message
How do I stop "Formula omits adjacent cells" error message?
HansVogelaar
Feb 04, 2022MVP
Select File > Options.
Select Formulas in the navigation pane on the lrft.
Clear the check box "Formulas which omit cells in a region" in the "Error checking rules" section.
Click OK.