O'Reilly logo

Absolute Beginner’s Guide to Microsoft® Office 2003 by Jim Boyce

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 18. From Simple Addition to What-ifs: Formulas

In this chapter

  • Using basic math functions in Excel

  • Reusing formulas in a spreadsheet

  • Using values or results from other sheets or files

  • Playing what-if to analyze figures

A spreadsheet would be mostly useless if all you could do with it was enter numbers and text in cells. The main purpose of a spreadsheet is to analyze information, and without formulas, most analysis would be impossible.

This chapter describes basic math functions and how to use them in Excel, as well as how to create formulas to manipulate and analyze the information in a spreadsheet.

Understanding Cell References and Operators

Before you can start building formulas, you need to understand two key topics: cell references and operators. ...

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