How to Use the Iterative Method on an Excel Spreadsheet

Save

Microsoft Excel is one of the most popular--and most powerful--spreadsheet programs on the market. Using the advanced calculation features of Microsoft Excel 2007 makes the program even more useful and versatile. By setting the iterative calculation method, users can have the program recalculate itself for a specific number of cycles or until a particular set of criteria is met.

  • Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet you want to change to the iterative calculation method.

  • Click the Office button and choose "Excel Options." Choose "Formulas" from the list.

  • Go to the "Calculations Options" section and choose the "Enable Iterative Calculation" check box option. Type a number in the "Maximum Iterations" box. The higher the number of iterations, the longer it will take the spreadsheet to recalculate.

  • Type a number in the "Maximum Change" box. The smaller this number, the more accurate the results of the formula will be. But as this number gets smaller, the spreadsheet will also take longer to calculate.

  • Click the Office button and choose "Save" to save the spreadsheet with the iteration changes.

References

  • Photo Credit computers screen 2 image by chrisharvey from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!