Enable iterative calculation in Google Sheets
Open File > Settings > Calculation and turn on Iterative calculation. Set Max number of iterations to 50 and Convergence threshold to 0.05, then save. Do not change any cell values.
Verified by JosephineAbout 60 secondsOpen File > Settings > Calculation and turn on Iterative calculation. Set Max number of iterations to 50 and Convergence threshold to 0.05, then save. Do not change any cell values.
Step-by-step
Select the targetOpen File > Settings > Calculation and turn on Iterative calculation.
Complete the next actionSet Max number of iterations to 50 and Convergence threshold to 0.05.
Apply the changesave.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
Iterative calculation is enabled with 50 maximum iterations and a 0.05 convergence threshold.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. Iterative calculation is enabled with 50 maximum iterations and a 0.05 convergence threshold.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Item | Amount |
| North | 120 |
| South | 180 |
Video transcript
- Open the prepared Calculation settings spreadsheet.
- Select the target. Open File > Settings > Calculation and turn on Iterative calculation.
- Complete the next action. Set Max number of iterations to 50 and Convergence threshold to 0.05.
- Apply the change. save.
- Iterative calculation is enabled with 50 maximum iterations and a 0.05 convergence threshold.