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