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.
Finds the sum of the numbers in the specified cells
Finds the average of the numbers in the specified cells
Finds the number of cells in the specified range that contain numbers
Finds the largest value in the specified cells
Finds the smallest value in the specified cells