Forum Discussion

Hugh Oake's avatar
Hugh Oake
Copper Contributor
Oct 03, 2018

Error "The formula in this cell refers to a range that has additional numbers adjacent to it." Formu

Error "The formula in this cell refers to a range that has additional numbers adjacent to it." Formula "=IF(OR(ISBLANK(O13)),"",(SUM(G12:G13)*0.09/365*O13))" what's wrong? I like for this in a column...
Excel
SergeiBaklan's avatar
SergeiBaklan
MVP
Oct 03, 2018

Hi Hugh,

 

You have a circular reference, at least in S11 the formula is

=IF(OR(ISBLANK(N12)),"",( SUM($R$2:S11)))

which refers to itself. Same for S12, etc.

 

  • Hugh Oake's avatar
    Hugh Oake
    Copper Contributor
    Oct 03, 2018
    What needs to be changed? Thanks.
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Oct 03, 2018

      I didn't catch what you'd like to calculate, at least the formula shall not refer to itself. Perhaps something like

      =IF(OR(ISBLANK(N12)),"",SUM($R$2:R11)+SUM($S$2:S10))

      but again, I'm not sure what is the business logic behind

      • rebeccahibben's avatar
        rebeccahibben
        Copper Contributor
        Dec 02, 2018

        I have the same error message, but I don't know what a circular reference is. Why is it bad?

Resources