Problems creating iterative calculations in If statements

%3CLINGO-SUB%20id%3D%22lingo-sub-1938102%22%20slang%3D%22en-US%22%3EProblems%20creating%20iterative%20calculations%20in%20If%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938102%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20support%20directed%20me%20to%20look%20for%20some%20help%20with%20my%20issue%20here.%20I%20am%20currently%20trying%20to%20do%20some%20modeling%20which%20requires%20some%20iterative%20if%20statements%20such%20as%26nbsp%3B%3CSPAN%3E%26nbsp%3B%22%3DIF%24D10%3D(0%2C25%2CD10%20D75%2F1000%24)%22%20inside%20of%20cell%20D10.%20This%20method%20has%20worked%20for%20my%20professor%20and%20colleagues%2C%20infact%20I%20have%20an%20entire%20model%20from%20a%20colleague%20that%20when%20I%20open%20and%20enable%20editing%20all%20data%20connected%20to%20cells%20with%20similar%20If%20statements%20are%20plagued%20with%20a%20%23NAME%20error%2C%20which%20is%20also%20happening%20whenever%20I%20try%20to%20make%20use%20of%20these%20formulas%20in%20my%20model.%20Both%20my%20colleague%20and%20I%20are%20running%20Excel%20365%20on%20a%20PC%2C%20so%20this%20has%20led%20me%20to%20believe%20the%20issue%20is%20somewhere%20in%20my%20settings%2Foptions.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938137%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20creating%20iterative%20calculations%20in%20If%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884483%22%20target%3D%22_blank%22%3E%40aaroncre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20the%20following%20link%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fremove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fremove-or-allow-a-circular-reference-8540bd0f-6e97-4483-bcf7-1b49cd50d123%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20activate%20iterative%20calculation%20from%20File%20Tab%20-%20Options%20-%20Formulas%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ilgar_Zarbaliyev_0-1606607127706.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F236467i989B40444F6BE8EA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ilgar_Zarbaliyev_0-1606607127706.png%22%20alt%3D%22Ilgar_Zarbaliyev_0-1606607127706.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938138%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20creating%20iterative%20calculations%20in%20If%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481821%22%20target%3D%22_blank%22%3E%40Ilgar_Zarbaliyev%3C%2FA%3E%26nbsp%3BThat's%20already%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938139%22%20slang%3D%22en-US%22%3ERE%3A%20Problems%20creating%20iterative%20calculations%20in%20If%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938139%22%20slang%3D%22en-US%22%3EI%20wonder%20if%20you%20can%20send%20me%20file%20itself.%3C%2FLINGO-BODY%3E
New Contributor

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

@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:

Ilgar_Zarbaliyev_0-1606607127706.png

 

Good luck

 

 

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.

 

@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
=IF$D10=(0,25,D10+D75/1000)

Sorry thats what it should say.

@aaroncre 

That means

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

or

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