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 to work for each line. 

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.

     

      • 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

Resources