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

[Hugh Oake]

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. 

[#2]

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.

[#3]

What needs to be changed? Thanks.

[#4]

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

[#5]

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

[#6]

Please check https://www.ablebits.com/office-addins-blog/2015/12/15/circular-reference-excel/

[#7]

Thank you very much for your help. I love to be as good with this spreadsheet as you are.