Forum Discussion
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
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- =IF$D10=(0,25,D10+D75/1000)
Sorry thats what it should say.
- I wonder if you can send me file itself.
Ilgar_Zarbaliyev Due to the nature of the data I cannot. Also I am aware the issue is local to my computer.
Hi there,
Please note the following link:
You should activate iterative calculation from File Tab - Options - Formulas:
Good luck
Ilgar_Zarbaliyev That's already done.
