Circular Calculations

Today Google is launching Iterative calculation in Google Sheets.

In other words they are trying to prevent errors that we get when performing complex calculations.

Inside Google Sheet follow these steps: File > Spreadsheet settings > Calculation > Iterative calculation.

The new menu will open up and allow you to set the maximum number of times a calculation with a circular reference can take place.

You can even specify a “convergence threshold, when the successive calculations differ by less than the threshold value, the calculations will stop.

They have also set the Android UI easier to right-to-left language settings to read an navigate.

It is also now possible to search the menus in Sheets on the web, like in Docs and Slides.

Google On!