Iterative Calculations In Excel How To Change That

Press question mark to learn the rest of the keyboard shortcuts Log in sign up User account menu 2 Spreadsheets - C268 - Practice Exam - Stuck on Event Profitability.

This is calculated as the number of employees needed for each product type times the salary (per employee) in the Model Inputs section.

Employees make the same salary despite the product type.) This will create a circular reference in your worksheet.

You will need to change the options in Excel to appropriately account for the circular reference.

Here is a screenshot of the cell in question with the function at the top.

For the life of me I cant figure out what they mean by change the options in Excel to appropriately account for the circular reference.

I feel like it is something obvious, but Im kicking myself in the head that I cant figure it out.

Iterative Calculations In Excel How To Change That

But in all actuality, they literally tell you how to change that option in the lesson.

File - Options - Formulas Under calculation options check the option to Enable iterative calculation level 2 B.S.

Information Technology Original Poster 1 point 1 year ago Thank you Yes, I noticed that just a few minutes after I posted this.

I felt silly, but I will leave the post up in case someone else needs help.

B.S. Information Technology Original Poster 1 point 1 year ago If anyone sees this later, you just have to do this: If youre using Excel 2010 or later, click File Options Formulas.

If youre using Excel for Mac, click the Excel menu, and then click Preferences Calculation.

If youre using Excel 2007, click the Microsoft Office Button Office button image, click Excel Options, and then click the Formulas category.

In the Calculation options section, select the Enable iterative calculation check box.

If you dont understand something just skip it you only have to get like a 68 to pass.

View entire discussion ( 5 comments) More posts from the WGU community Continue browsing in rWGU rWGU Place for Western Governors University students, faculty and alumni.

Members 324 Online Created Mar 25, 2011 Join help Reddit App Reddit coins Reddit premium Reddit gifts about careers press advertise blog Terms Content policy Privacy policy Mod policy Reddit Inc 2020.

Iterative Calculations In Excel For Mac