Microsoft Office Tutorials and References
In Depth Information
The Formulas Tab in Excel 2013
=PI()
Note
Chapters 11 through 15 cover all 463 functions. This chapter covers
a number of the most commonly used functions.
The arguments for a function should be entered in the correct order, as spe-
cified in this topic or Excel Help. For example, the PMT() function expects the
arguments to have the interest rate first, followed by the number of periods,
followed by the present value. If you attempt to send the arguments in the
wrong order, Excel happily calculates the wrong result.
In many cases, you can enter arguments as numbers or as cell references.
For example, all these formulas are valid:
=SUM(1,2,3^2,4/5,6*7)
=SUM(A1:A9,C1,D2,Sheet2!E3:M10)
=SUM(A1:A9,100,200,B3*5)
Note
Excel functions can return a number of errors. This happens most
frequently when one of the arguments passed to the function is outside
the range of what the function expects. When you receive a #NUM!,
#VALUE!, or #N/A error, you should look in Excel Help for the func-
tion. The Remarks section usually indicates exactly what problems
can cause each type of error.
The Formulas Tab in Excel 2013
The Formulas Tab in Excel 2013
One way to find functions in Excel 2013 is on the Formulas tab. This tab of-
fers the Insert Function, AutoSum, Recently Used, Financial, Logical, Text,
Date & Time, Lookup & Reference, Math & Trig, and More Functions icons.
As shown in Figure 10.1 , when you click the More Functions icon, a drop-down
with six additional function groups Statistical, Engineering, Cube, Informa-
tion, Compatibility, and Web appears.
Search JabSto ::




Custom Search