O'Reilly logo

Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables by Denise Etheridge

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

Appendix C. FORMULA BASICS

Formula Basics

Formulas are the building blocks of data analysis in Excel. They enable you to calculate and compare the values in cells. This section serves as a reference for users who are not familiar with Excel.

Formulas contain two basic elements: an equal sign, followed by an expression, which tells Excel what to do. You can use any combination of functions, cell references, named ranges, constants, and operators to create a formula. If Excel cannot properly evaluate your formula, an error message appears.

Excel provides a large variety of operators you can use to create formulas, most of which are the arithmetic operators; however, Excel also provides comparison operators, reference operators, and a text operator. ...

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