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?

Nov 21, 2022 in Others 293 views

## 1 answer to this question.

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.
• 63,160 points

## How to multiply by a percentage range in Excel

The following would yield an array from ...READ MORE

## How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

## How to save a new sheet in an existing excel file, using Pandas?

import pandas as pd import numpy as np path ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE