How to fix a circular reference error by if condition in excel file

Question

I have 3 A, B, C columns. I have put some formulas on B and C, something like this.

C1: PRODUCT(A1:B1)

B1: SUM(A1+C1)

But I have the circular reference warning.

and I change the formula with the if condition to:

C1: =IF(OR(ISBLANK(A1), ISBLANK(B1)), "", PRODUCT(A1:B1))

B1: =IF(OR(ISBLANK(A1), ISBLANK(C1)), "", A1+C1)

But I still have the circular reference warning. How do I avoid it?

Answer 1

Circular reference in this context refers to the fact that the formulas you enter into the various cells depend on one another, making it impossible to calculate them without creating an infinite cycle.

It is important to observe A*B in column C. A+C should be in column B.

Therefore, column C would likewise alter because it is A*B if, for instance, column B is calculated as A+C. And because column C has changed and column B should be A+C, it would also need to recalculate column B. so forth.

I hope this helps you.