Forum Discussion

Kpamuksuz's avatar
Kpamuksuz
Copper Contributor
Dec 05, 2025

#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

No RepliesBe the first to reply

Resources