# 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

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

## More Information

**Formula** Tab of **Options** Dialog Box

### 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.

## See Also

Options, Options: Display, Options: Edit, Options: Custom List, Options: File, Options: Fonts, Options: Others