Microsoft Office Tutorials and References

In Depth Information

**Using functions in your formulas**

New Functions in Excel 2013

Excel 2013 includes more than 50 new worksheet functions.

Nearly all the new functions are highly specialized functions that will appeal to those in engineering

or math-related ﬁ elds.

But there are some new functions that might appeal to a more general audience:

■
ISFORMULA
: Returns
TRUE
if the referenced cell contains a formula

■
FORMULATEXT
: Returns the formula in the referenced cell, as text

■
SHEET
: Returns the sheet number of the referenced sheet. For example, =SHEET(“Sheet3”)

returns the sheet number for Sheet3.

■
SHEETS
: Returns the number of sheets in a workbook. For example,
=SHEETS()
returns the

number of sheets in the workbook.

■
IFNA
: If a reference contains a
#NA
error, returns other text you specify

Keep in mind that these functions are not backward compatible. If you use any of these new functions,

they won’t work if the ﬁ le is opened with an earlier version of Excel.

Function arguments

In the preceding examples, you may have noticed that all the functions used parentheses.

The information inside the parentheses is the
list of arguments.

Functions vary in how they use arguments. Depending on what it has to do, a function

may use:

■
No arguments

■
One argument

■
A ﬁ xed number of arguments

■
An indeterminate number of arguments

■
Optional arguments

An example of a function that doesn’t use an argument is the
NOW
function, which returns

the current date and time. Even if a function doesn’t use an argument, you must still

provide a set of empty parentheses, like this:

=NOW()

15

If a function uses more than one argument, you must separate each argument with a

comma. The examples at the beginning of the chapter used cell references for arguments.

Excel is quite ﬂ exible when it comes to function arguments, however. An argument can