Formula Error Message

Occasional Visitor

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

1 Reply

@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.