Backwards Compatibility

Most of these functions are still available for backwards compatibility.
The JIS function was actually removed in Excel 2013.

CEILING.PRECISE(CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure.
CELLReturns the text string indicating information about a cell.
DATEDIF(Compatibility) Returns the number of units between two dates.
FALSEReturns the logical value False.
FLOOR.PRECISE(FLOOR.MATH) Returns the number rounded down to the nearest integer or significant figure.
ISO.CEILING(CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure (renamed).
ISPMT(IPMT) Returns the interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
JIS(Removed) Returns the text string converted from single byte to double byte characters (renamed).
NReturns the value converted to a number.
NAReturns the error value #N/A.
SINGLEReturns the value from a cell range which is the intersection of a row OR a column.
TReturns the text string of the value given.
TRUEReturns the logical value True.
VALUE(NUMBERVALUE) Returns the number that a text string represents (renamed).
CEILING.PRECISE
(CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure.
CELL
Returns the text string indicating information about a cell.
DATEDIF
(Compatibility) Returns the number of units between two dates.
FALSE
Returns the logical value False.
FLOOR.PRECISE
(FLOOR.MATH) Returns the number rounded down to the nearest integer or significant figure.
ISO.CEILING
(CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure (renamed).
ISPMT
(IPMT) Returns the interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
JIS
(Removed) Returns the text string converted from single byte to double byte characters (renamed).
N
Returns the value converted to a number.
NA
Returns the error value #N/A.
SINGLE
Returns the value from a cell range which is the intersection of a row OR a column.
T
Returns the text string of the value given.
TRUE
Returns the logical value True.
VALUE
(NUMBERVALUE) Returns the number that a text string represents (renamed).

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext