Forum Discussion
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
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
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
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.