New Functions for 2013
The following Functions are new in Excel 2013.
- A complete list is below, but here are some the average user might find helpful.
- DAYS
- Syntax: DAYS(end_date, start_date)
Returns the number of days between two dates.
If cell A1 contains the date 6/9/2013 and cell B1 contains the date 9/15/2013, then =DAYS(B1,A1) will return a value of 98. It will return the same value as =B1-A1, but some people understand the function better.
- IFNA
- Syntax: IFNA(value, value_if_na)
Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.
Works the same as IFERROR, but is specific to the #N/A error.
- SHEETS
- Syntax: SHEETS(reference)
Returns the number of worksheets in the reference.
=SHEETS() will return the number of sheets in the current workbook. This function counts all types of sheets; worksheets, chart sheets, and hidden sheets!
- ISFORMULA
- Syntax: ISFORMULA(reference)
Checks whether a reference is to a cell containing a formula and returns TRUE or FALSE.
- ARABIC
- Syntax: ARABIC(text)
Converts a Roman numeral to Arabic.
If cell A1 contains XXXIV (or xxxiv), =ARABIC(A1) will return 34.
- New Functions in 2013:
| Engineering Functions |
Math and Trig Functions |
Financial Functions |
Statistical Functions |
| BITAND |
ARABIC |
PDURATION |
BINOM.DIST.RANGE |
| BITOR |
ACOT |
RRI |
GAMMA |
| BITLSHIFT |
ACOTH |
Information Functions |
GAUSS |
| BITRSHIFT |
BASE |
ISFORMULA |
PERMUTATIONA |
| BITXOR |
CEILING.MATH |
SHEET |
PHI |
| IMCOSH |
COMBINA |
SHEETS |
SKEWP |
| IMCOT |
COT |
Logical Functions |
Text Functions |
| IMCSC |
COTH |
IFNA |
NUMBERVALUE |
| IMCSCH |
CSC |
XOR |
UNICHAR |
| IMSEC |
CSCH |
Lookup Functions |
UNICODE |
| IMSECH |
DECIMAL |
FORMULATEXT |
Web Functions |
| IMSINH |
FLOOR.MATH |
Time and Date Functions |
ENCODEURL |
| IMTAN |
MUNIT |
DAYS |
FILTERXML |
|
SEC |
ISOWEEKNUM |
WEBSERVICE |
|
SECH |
|
|
Return to the Top
