How to solve the problem with Circular reference in Excel
Circular reference is an irritating problem and when it happens, mostly the user doesn’t know what to do. The problem and the solution are simple. You have actually used the reference of the same cell in which you are writing the formula. As shown in the video example, you have written the formula ‘=b4*c4’ and you are writing the formula in C4!
In fact, Excel shows a warning about the circular reference in the status bar also apart from the pop-up window whose message is really not easy to understand. If you click on the ‘formulas tab’ and then on ‘evaluate formula’ under ‘formula auditing’ you can identify and correct the error. Of course, you can correct the error in the formula cell itself by referring to the correct cells.
Remove or allow a circular reference