Excel TutorialLesson 12Free preview

Excel Formulas

This lesson is part of Excel · All levels

Summary

The formula is the heart of Excel: an expression that calculates the values of numbers, cells, and operators. Excel follows the order of mathematical operations, so multiplication and division are calculated before addition and subtraction. You can also display the entire formula on the sheet with the Ctrl+` button for quick audit.

Key points

The formula starts with = and can contain numbers, cells, operators, and functions.
The order of operations: rank, then * and /, then + and -
The formula divided by zero shows #DIV/0!
Ctrl+` (grave accent) displays all the formulas instead of the result

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.