Forum Discussion
#Name? error in a formula adjusted for circular reference
How can I solve #Name? error in formula:
=H2+(I2*Parameters_2026!$G$1)+(I2*Parameters_2026!$G$3)+(I2*Parameters_2026!$G$5)+((I2-I2*Parameters_2026!$G$1-I2*Parameters_2026!$G$3)*İNDEX(Parameters_2026!$C$3:$C$7;MATCH(MAX(I2;1);Parameters_2026!$A$3:$A$7;1))).
Where:
H2 → Net Salary
I2 → Gross Salary (to be calculated iteratively)
Parameters_2026!$G$1 → Employee Social Insurance Rate (0,14 of Gross Salary)
Parameters_2026!$G$3 → Employee Unemployment Insurance Rate (0,01 of Gross Salary)
Parameters_2026!$G$5 → Stamp Tax Rate (0,00759 of Gross Salary)
INDEX + MATCH → Finds income tax rate (range C3:C7) applicable for Gross Salary amount (A3:A7 range)
Iterative calculation enabled for Maximum Iterations: 1000 and Maximum Change: 0.000001.
Thank you in advance