Unless you use Google Sheets daily, you will not know how many types of complex calculations you’d have to indulge in. Several factors often complicate the processes, especially when it comes to making calculations that are beyond the simple available features. This is where the problems are.
To tend to these issues, Google Sheets has launched a new setting called the Iterative Calculation that allows easier calculations. This allows the users to set the maximum number of times that a specific calculation with the circular reference can be done in Google Sheets. It’s not the easiest feature to use, especially if you are a novice with Sheets. Well, that’s exactly why we are here to make the process easier for you.
This post explores this new additional feature of how to enable iterative calculation in Google Sheets in detail and how you can make the most use out of it while working on different spreadsheets.
- Open Google Sheet:
- Next, Click the File tab at the top of the window:
- Next, select the “Spreadsheet settings” from the menu:
- Next, select the Calculation tab near the center of the window:
- Click the Iterative calculation dropdown and turn it on, then specify the Max number of iterations and the Threshold.
- Next, click the Save settings button to save the settings: