Backwards Compatibility

The functions listed below should not be used.
The functions listed below are only included to provide backwards compatibility.
The SINGLE function was removed in Excel 365.
The JIS function was removed in Excel 2013.
The functions in the Compatibility Category should only be used if you need compatibility with Excel 2007.

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 days, months or years 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).
ISERR	(ISERROR) Returns the value True or False depending if the value is an error.
ISPMT	(IPMT) Returns the interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
JIS	(Removed in 2013) (DBCS) 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	(Removed in 365) 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).

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 days, months or years 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).
ISERR (ISERROR) Returns the value True or False depending if the value is an error.
ISPMT (IPMT) Returns the interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
JIS (Removed in 2013) (DBCS) 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 (Removed in 365) 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).