# Formula Basics

Formulas contain information to perform a numerical calculation such as adding, subtracting, or multiplying. All formulas must start with an equal sign (=). Then they specify more information, like the values to calculate or function to use to calculate the values.

## Create Formula

Click the cell where you want to add the formula.

Press = .

Now you have to specify what to calculate.

Click a cell or type the cell reference in the formula bar to add it to the formula.

Add an operator. Operators include:

- + (plus)
- – (minus)
- * (multiply)
- / (divide)

Add additional cells to a formula by typing their cell reference in the formula bar or clicking the cell(s).

**Tip:**To change the order of what is calculated, enclose the part of the formula to be calculated first in parentheses.Click the Enter button when you’re finished.

In a fraction of a second, Excel calculates the equation and places the result in the cell.

**Shortcut:**Press Enter .**Tip:**If you make a change to any value in a cell that’s referenced in the formula, Excel will automatically recalculate the changes.

## Edit a Formula

Select the cell with the formula you want to edit.

Click in the Formula bar and edit the formula as necessary.

**Tip:**You can also double-click a cell to switch to edit mode, then edit the formula right in the cell.Click the Enter button when you’re finished.

**Shortcut:**Press Enter .The formula is updated to reflect the changes.

## Use a Function

In Excel, a function is a preset formula. There are several hundred functions available. Some are simple, such as the Sum function. Others are much more complex and contain several different arguments. Arguments are the data used by the function to make a calculation. They appear within the parentheses in the function.

Function Categories | |
---|---|

Financial | Functions that are used to calculate interest, payments, loans, etc. |

Date & Time | Functions to calculate date and times values. |

Math & Trig | Math and trigonometry functions, such as SUM, COS, and TAN. |

Statistical | Functions that calculate averages, standard deviations, etc. |

Lookup & Reference | Functions that lookup or reference values. |

Database | Functions that lookup or calculate values in a list or database. |

Text | Functions that can be used with text or labels. |

Logical | Conditional functions (IF…THEN). |

Information | Functions that return information about values and the worksheet itself. |

Engineering | Functions used in engineering calculations. |

Cube | Functions that extract data from OLAP cubes. |