Chapter 4. CREATING FORMULAS

Understanding Formulas

In Excel, you use formulas. A formula is an equation that performs a calculation. A formula can consist of operators, functions, numbers, text, and cell references. You place formulas in cells. You can click a cell and then type your formula into the formula bar or you can type your formula directly into a cell. You start most formulas by typing an equal sign (=).

Operators

You use operators to tell Excel the type of calculation you want to perform. There are four types of operators: arithmetic, comparison, text concatenation, and reference.

Arithmetic Operators

Use arithmetic operators to perform mathematical calculations such as addition (+), subtraction (–), multiplication (*), division (/), percent ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial