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...
What needs to be changed? Thanks.
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
I have the same error message, but I don't know what a circular reference is. Why is it bad?
Thank you very much for your help. I love to be as good with this spreadsheet as you are.
