Formulas

The formulas are what make a spreadsheet a spreadsheet. Excel allows you to introduce flexible used values ​​(or text) in cells to calculate the result. When you enter a formula in a cell, the result of the formula appears in the cell. If you change any of the cells used by a formula, the formula recalculates and displays the new result.

Formulas can be simple mathematical expressions, or can use some powerful functions that are built into Excel. In Picture shows an Excel spreadsheet set up to calculate the monthly loan payment. The worksheet contains the values, text and formulas. The cells in column B contain text. Column C contains four values ​​and two formulas. The formulas are in cells C7 and 11. Column E, as a reference, shows the actual content of the cells in column C.