web analytics

Comprehending Formulas in Excel

A formula is an expression that measures a cell’s value. The functions are formulas and are already available in Excel.

Cell A3 below for instance, includes a formula that adds the value of cell A1

Cell A3 below for instance has the SUM function which calculates the sum of the range A1:A2. Description: Function in Excel

How to enter a Formula

To enter a formula, practice the following steps.

1. Choose a cell.

2. Type an equal sign (=), to let Excel know you are entering a formula

3. For instance, type the formula A1+A2.

Tip: simply pick cell A1 and cell A2 instead of typing A1 and A2.

4. Adjust cell A1’s value to 3.

Excel recalculates the value of cell A3 automatically. This is one of the most important features of the most important features of Excel!

Editing a Formula

Excel displays the value or formula of the cell in the formula bar when you pick a cell.

1. Click in the formula bar and change the formula in order to edit a formula.

2. Just click Enter.