logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Printing tricks
November 18, 2021
Tips and Tricks of MS PowerPoint
December 3, 2021

Circular Referencing Solution

November 25, 2021

A "circular reference" is created when you refer to the same cell either directly or indirectly

Here is a simple method to solve the circular referencing problem

Suppose a company XYZ gives commission to its Manager on the Profit after tax after charging the commission

Here is the data used

Circular Referencing Solution 01

Manager’s Commission is 5% of the PAT of XYZ Company. But to calculate PAT, calculating Manager’s Commission is required. This will cause “circular referencing” error

Circular Referencing Solution 02

"Excel will show a “circular referencing” error. To solve it Go to the File> then to options Tab

Circular Referencing Solution 03

Options Tab go to Formulas and Check the “Enable Iterative Calculation.” After checking the box, click on OK

Circular Referencing Solution 04

Once you click on OK the problem of “circular referencing” will be solved

Contributor:Ankit Agarwal.

Freelancer at Upwork, Ex Junior Associate at Leveraged Growth. I work on MS Excel MS Word Projects to fulfill client's requirements. I have a keen interest in Automation, Visualization, Analysis of different data and continuously trying to learn and improve on it. Also, I'm pursuing CFA and have a bachelor's degree in Accounts and Finance.
WhatsApp Image 2021-04-16 at 17.04.03
Share
0

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 18, 2021

Printing tricks


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'