Formula Error Message

[Jga-123456]

How do I stop "Formula omits adjacent cells" error message?

[#2]

@Jga-123456 

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.