Feb 04 2022 08:19 AM
How do I stop "Formula omits adjacent cells" error message?
Feb 04 2022 08:46 AM
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.