New Contributor

# Problems creating iterative calculations in If statements

Hello,

Microsoft support directed me to look for some help with my issue here. I am currently trying to do some modeling which requires some iterative if statements such as  "=IF\$D10=(0,25,D10 D75/1000\$)" inside of cell D10. This method has worked for my professor and colleagues, infact I have an entire model from a colleague that when I open and enable editing all data connected to cells with similar If statements are plagued with a #NAME error, which is also happening whenever I try to make use of these formulas in my model. Both my colleague and I are running Excel 365 on a PC, so this has led me to believe the issue is somewhere in my settings/options.

7 Replies

# Re: Problems creating iterative calculations in If statements

Hi there,

https://support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-8540bd0f-6e97-4483-b...

You should activate iterative calculation from File Tab - Options - Formulas:

Good luck

# RE: Problems creating iterative calculations in If statements

I wonder if you can send me file itself.

# RE: Problems creating iterative calculations in If statements

@Ilgar_Zarbaliyev Due to the nature of the data I cannot. Also I am aware the issue is local to my computer.

# Re: Problems creating iterative calculations in If statements

That will be great if you provide exact formula you use since one which is in your post shall not work on any computer - incorrect syntax for IF(), there are no such numbers as 1000\$, etc. Perhaps you mean

``=IF(\$D10=0,25,D10)*D75/1000``

# Re: Problems creating iterative calculations in If statements

=IF\$D10=(0,25,D10+D75/1000)

Sorry thats what it should say.

# Re: Problems creating iterative calculations in If statements

That means

``````=IF(\$D10=0,25,D10+D75/1000)

or

if d10 is zero
then d10=25
else d10=d10+d75/1000``````