Microsoft Office Tutorials and References
In Depth Information
8. On the Formulas tab, in the Defined Names group, click Define Name .
The New Name dialog box opens.
9. In the Name field, type V102LastWeek .
10. Verify that the definition in the Refers to field is =MilesLastWeek!$C$5:$H$5 .
11. Click OK .
Excel creates the name and closes the New Name dialog box.
CLEAN UP Save the VehicleMiles workbook, and then close it.
Creating Formulas to Calculate Values
After you add your data to a worksheet and define ranges to simplify data references,
you can create a formula, which is an expression that performs calculations on your data.
For example, you can calculate the total cost of a customer’s shipments, figure the
average number of packages for all Wednesdays in the month of January, or find
the highest and lowest daily package volumes 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,
not text. After the equal sign, type the formula. For example, you can find the sum of
the numbers in cells C2 and C3 by using the formula =C2+C3 . After you have entered a
formula into a cell, you can revise it by clicking the cell and then editing the formula in
the formula box. For example, you can change the preceding formula to =C3-C2 , which
calculates the difference between the contents of cells C2 and C3.
Troubleshooting If Excel treats your formula as text, make sure that you haven’t accidentally
put a space before the equal sign. Remember, the equal sign must be the first character!
Typing the cell references for 15 or 20 cells in a calculation would be tedious, but
Excel makes it easy to enter complex calculations. To create a new calculation, click
the Formulas tab, and then in the Function Library group, click Insert Function. The
Insert Function dialog box opens, with a list of functions, or predeined formulas,
from which you can choose.