Geek Answers Handbook

Workaround for Formula Drop Adjacent Cells

In Excel with the following function:

=IF(AND(N3=1,ISNUMBER(D3),ISNUMBER(E3)),SUM(D3:E3)-2,IF(AND(N3=1,D3="",E3=""),G3,IF(N3=1,"",IF(AND(N3=0,ISNUMBER(D3)),D3-1,IF(AND(N3=0,ISNUMBER(E3)),E3-1,IF(AND(N3=0,D3="",E3=""),G3,IF(N3="","",G3)))))))

I get an error message:

Formula omits adjacent cells

How can I correct the formula to avoid a mistake?

+8
source share
2 answers

The error you get means that your formula has cells close to those that have the same format, and Excel believes that you accidentally missed them. For example, if you have

  A 1 87 2 76 3 109 4 65

then the formula

 =SUM(A1:A3)

will give a similar error. Thus, without seeing the source data, it is difficult to answer your question. I would recommend updating the formula as it suggests, and then see if it includes all the cells you need. If this is not the case, simply discard and ignore the error.

+11
source

Just use the $ sign before mentioning the cell value, and this error should be fixed.

For instance,

$ A $ 1 instead of A1

0
source

More articles:


All Articles