Options: Formula

In the Formula tab of the Options dialog box, you can set automatic/manual computation methods and formula options.

Steps

To calculate now

1. Click File > Options.
2. In the Options dialog box, select the Formula tab.
3. In Computation Method, click Calculate Now.
4. The dialog box closes and all values and formulas in the open worksheet are recalculated.

Computation Method

To calculate in a Cell worksheet, select a computation method.

• Automatic
Calculate all dependent formulas automatically every time you change a value, formula, or name. This is the default computation method.
• Manual
Calculate the open workbook if you click Calculate Now in the Formula tab of the Options dialog box.
• Calculate Now (SHIFT+F9) Button
If you click this button, all open worksheets including data tables will be calculated.
• Recalculate All (F9) Button
If you click this button, all worksheets will be recalculated.
• Iteration
Select iteration. If the calculation is done over 100 times or if all values change to less than 0.001 when Iteration is not selected, the calculation will stop. You can limit the number of iterations by changing numbers in both the Maximum Iterations box as well as the Maximum Change box.
• Maximum Iterations
To change maximum iterations and maximum change, type a number in the Maximum Iterations box and the Maximum Change box.
• Maximum Change
To change the maximum iterations and maximum change, type a number in the Maximum Iterations box and the Maximum Change box.

Formula Options

• Enable Formula AutoComplete
When you type part of a formula, a list of formulas that start with the typed characters will be displayed on a list. You can enter a formula simply by selecting one from the list.
• 1904 Date System
Calculate dates based on the year 1904. If you use this option when you read a saved document from a platform based on the year 1904, you can display date information properly.
• Expand Formula Automatically
If you type a formula in a cell and type '=' at the end, the formula will be split in to multiple cells.
For Example: If you type 1+2= in the cell A1, 1 will be automatically inserted in the cell A1, 2 in the cell B1, and =A1+B1 in the cell C1.
If you want to enter a formula including the equal sign (=) in a cell, this option must not be selected.
• Expand to Right
The formula will expand to the right from the cell in which it is typed.
For Example: If you type 1+2= in the cell A1, 1 will be automatically inserted in the cell B1, 2 in the cell C1, and =B1+C1 in the cell A1.