Problems creating iterative calculations in If statements

[aaroncre]

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.

[#2]

@aaroncre 

Hi there,

Please note the following link:

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

[#3]

@Ilgar_Zarbaliyev That's already done.

[#4]

I wonder if you can send me file itself.

[#5]

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

[#6]

@aaroncre 

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

[#7]

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

Sorry thats what it should say.

[#8]

@aaroncre 

That means

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

or

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