Creating Formulas to Calculate Values

Creating Formulas to Calculate Values

Once you’ve added your data to a worksheet and defined ranges to simplify data references, you can create a formula, or an expression that performs calculations on your data. For example, you can calculate the total cost of a customer’s order, figure the average sales for all Wednesdays in the month of January, or find the highest and lowest daily sales for a week, month, or year.

To write an Excel formula, you begin the cell’s contents with an equal sign—when Excel sees it, it knows that the expression following it should be interpreted as a calculation and not text. After the equal sign, you type the formula. ...

Get Microsoft® Office Excel® 2003 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.