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