O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

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

Performing Custom Calculations by Creating Formulas

When you need to perform a custom calculation in a cell, use a formula rather than a function. All you need to do is type in a simple formula using the appropriate calculation operators, such as + signs for addition and signs for subtraction. In this section, you'll meet the comparison operators, try using them in a worksheet, and learn the order in which Excel applies them—and how to change that order.

Meeting Excel's Calculation Operators

To perform calculations in Excel, you need to know the operators for the different operations—addition, division, comparison, and so on. Table 13–1 explains the full set of calculation operators you can use in your formulas in Excel.

Using the Calculation ...

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