Microsoft Office Tutorials and References

In Depth Information

**Creating formulas to calculate values**

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 the equal sign is the

first character. If Excel still displays your formula as text, check whether the cell has the Tex t

format applied to it. If it does, change the cellâ€™s format to a format that suits the value you

want to calculate.

Entering 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 predefined formulas, from which you can choose.

The following table describes some of the most useful functions in the list.

Function

Description

SUM

Finds the sum of the numbers in the specified cells

AVERAGE

Finds the average of the numbers in the specified cells

COUNT

Finds the number of cells in the specified range that contain numbers

MAX

Finds the largest value in the specified cells

MIN

Finds the smallest value in the specified cells