Skip to Main Content
Microsoft® Office 2007 Simplified®
book

Microsoft® Office 2007 Simplified®

by Sherry Willard Kinkoph
February 2007
Beginner content levelBeginner
416 pages
10h 35m
English
Visual
Content preview from Microsoft® Office 2007 Simplified®

Chapter 11. working with formulas and functions

Understanding Formulas

You can use formulas to perform all kinds of calculations on your Excel data. You can build formulas using mathematical operators, values, and cell references. For example, you can add the contents of a column of monthly sales totals to determine the cumulative sales total. If you are new to writing formulas, this task explains all of the basics required to build your own formulas in Excel.

Formula Structure

Ordinarily, when you write a mathematical formula, you write the values and the operators, followed by an equal sign, such as 2+2=. In Excel, formula structure works a bit differently. All Excel formulas begin with an equal sign (=), such as =2+2. The equal sign immediately ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SharePoint® 2007 for Office 2007 Users

Microsoft® SharePoint® 2007 for Office 2007 Users

Martin W.P. Reid
Microsoft® Office 2010 Bible

Microsoft® Office 2010 Bible

John Walkenbach, Herb Tyson, Michael R. Groh, Faithe Wempen, Lisa A. Bucki

Publisher Resources

ISBN: 9780470045893Purchase book