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. |
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 | (Microsoft 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 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 (Microsoft 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). |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext