Forum Discussion

Copper Contributor

Aug 29, 2022

How to remove Circular reference (Need better formula)

Dear All, I need better formula to calculate the highlighted cells, which shows circular reference: Many Thanks Arvind

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Aug 29, 2022

Arvind Kaushik C6 refers to C9 and vice versa. That indeed causes a circular reference.

Start by explaining what value you would expect in C9, and why.

Arvind Kaushik
Copper Contributor
Aug 29, 2022
1. To Calculate Compensatory =CTC-BASIC-HRA-Conveyance-Bonus-Superannuation-PF
2.To Calculate PF=if BASIC<15000 then take minimum value between 1800 or sum(BASIC+Compensatry)*12%
here we are using PF in Point 1 & Point 2 hence circular ref. is coming, can we built a better formula to resolve this issue.

Thanks,
Arvind
- Riny_van_Eekelen
  Platinum Contributor
  Aug 29, 2022
  Arvind Kaushik Well, you can't have C6 and C9 depend on one-another. Rather than repeating what is already obvious from the picture, what would you want to see in C6 and C9, given all the other numbers in C3, C4, C5, C7, C8, and C10, if you had to calculate it manually?
  
  Edit: Unless, when you "Enable iterative calculation" in Options, Formulas.

Resources