Related Topics: | ||
You can set the options for performing calculations in the spreadsheet by choosing Sheet Options > Format and View > More Settings > Calculation Options to open the Calculation Options window.
If you select Automatic Recalculation the spreadsheet will automatically recalculate formulas when relevant values change. If you clear this option you must choose Sheet Options > Format and View > More Settings > Recalculate Formulas to recalculate the formulas and display the new results.
If you select Minimal Recalculation the spreadsheet will recalculate only the formulas containing references to a changed cell. This will prevent other cells from changing and displaying new results.
If you select Enable Iteration the spreadsheet will calculate until it iterates the number of times specified in the Maximum Iterations field or until all cells change by less than the amount specified in the Maximum Change field. This can be used to solve circular references.
If you select Precision as Displayed all cell values will be rounded to the displayed precision, which is set in the Format Cells window. For example, assume that the Precision as Displayed option is selected and the displayed precision has been set to two decimal places. If you enter a value with more than two decimal places, such as 0.236, the value will be rounded to two decimal places or 0.24. As shown below, when the Precision as Displayed option is not selected the spreadsheet will display only the specified number of decimal places but the cell itself will still contain the full number as you can see that when you look in the data entry bar.
Click OK to accept your selections. You can then choose Sheet Options > Format and View > More Settings > Recalculate Formulas to recalculate the formulas within the spreadsheet based on the changes that have been made in the Calculation Options window.
© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.