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
1 Reply
#NAME? error means you reference on something what Excel is not able to recognize, more details is here How to correct a #NAME? error - Microsoft Support It doesn't matter did you enable iterative calculation or not.
Quite often that happens due to typo. Here it could be strange "İ" in front of INDEX. perhaps something else.
