O'Reilly logo

Easy Office 2016 by Patrice-Anne Rutledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Working with Cell Formulas and Functions

Image

Formulas in an Excel worksheet perform calculations, such as adding, subtracting, averaging, or multiplying numbers. They’re also dynamic—for example, if you reference a cell address in a formula, the formula changes if the data in the cell changes.

At times, formulas can be complex and time-consuming to build. To simplify creating formulas, Excel also has a solid collection of different functions to assist you with your calculations. For example, you could use the AVERAGE function to average a series of numbers.

Cell Formula Basics

Creating a Simple Formula

You can use a simple formula ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required