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

0 votes

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 in Others by Kithuzzz
• 20,660 points
19 views

1 answer to this question.

0 votes
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.
answered Nov 21 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to multiply by a percentage range in Excel

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

answered Nov 8 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

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

answered Nov 17 in Others by narikkadan
• 37,660 points
27 views
0 votes
1 answer
0 votes
1 answer

How to unistall a file in Linux?

You can uninstall a file using the ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
829 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

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

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

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18 in Others by gaurav
• 22,040 points
71 views
0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
81 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
44 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP