Hi Experts,
I was calculating CTC and I ended up with an error #NUM/Circular Reference. I have attached the excel file for your reference.
In the attached file,
Column B is my actual CTC on which I want to do a breakup (split CTC into salary components).
Column T is final CTC, which should match with Coumn B (plus or minus 12rs is OK (can increase or decrease)).
Column T is sum of Column C to S
Column E should have the balancing figure of Column B - Column T
How do i get a value in Column E without an error? Please help me.
Thanks in advance.
Regards,
Harish S
Bookmarks