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.
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
■ 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:
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