Forum Discussion
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...
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.
What needs to be changed? Thanks.