Related Topics:

Analysis Workbooks

Calculation Options

You can set the options for performing calculations in the spreadsheet by choosing Sheet > Format and View > More Settings > Calculation Options.

After you change any of these options, click OK to save the changes and then choose Sheet > Format and View > More Settings > Recalculate Formulas to recalculate the formulas within the spreadsheet based on the changes that have been made.

The available options are:

Note that in BlockSim, it takes time to recalculate the formulas. We recommend to keep this option cleared, and manually recalculate the formulas as needed.

The behavior will differ based on the combination of options you select. For example, consider a simple scenario in which values entered directly into two cells are being added together:

If the cell uses the default number format (General)…

If the cell uses a custom number format (e.g., 0.00)…

The Precision as Displayed option has no effect:

  • Both the cell and the data entry bar show the non-rounded values.

  • The calculated result is based on the non-rounded values (10.005 + 10.005 = 20.01).

And if the Precision as Displayed option is cleared:

  • The cell shows the rounded value, but the data entry bar shows the original non-rounded value.

  • The calculated result is based on the non-rounded values (10.005 + 10.005 = 20.01).

And if the Precision as Displayed option is selected:

  • Both the cell and the data entry bar show the rounded value.

  • The calculated results are based on the rounded values
    (10.01 + 10.01 = 20.02).

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.