Backwards Compatibility
The functions listed below should not be used.
The functions listed below are only included to provide backwards compatibility.
Some of these functions were for compatibility with other spreadsheet programs.
The functions in the Compatibility Category should only be used if you need compatibility with Excel 2007.
| AVERAGEIF | (AVERAGEIFS) Returns the arithmetic mean of the numerical values that satisfies one condition. |
| CALL | (Removed in 2003) Returned the specification for a function or command using a registration ID. |
| CEILING | (CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure. |
| 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. |
| COUNTIF | (COUNTIFS) The number of numerical values that satisfies one condition. |
| DATEDIF | Returns the number of days, months or years between two dates. |
| DATESTRING | (Removed in 2003) Returned the system date in the MM-dd-yyyy format, using abbreviated month name. |
| ECMA.CEILING | (CEILING.MATH) Returns the number rounded up to the nearest multiple of significance. |
| FALSE | Returns the logical value False. |
| FLOOR | (FLOOR.MATH) Returns the number rounded down to the nearest integer or significant figure. |
| 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) Returned 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. |
| REGISTER.ID | (Removed in 2003) Returned the result after running an Excel 4.0 Macro function. |
| SINGLE | (Removed in 365) Returned the value from a cell range which is the intersection of a row OR a column. |
| SQL.REQUEST | (Removed in 2003) Returned the result after connecting to a data source and executes a SQL query. |
| SUBTOTAL | (AGGREGATE) The subtotal of values in a list, table or cell range (renamed). |
| SUMIF | (SUMIFS) The total of the numerical values that satisfies one condition. |
| 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). |
| AVERAGEIF (AVERAGEIFS) Returns the arithmetic mean of the numerical values that satisfies one condition. |
| CALL (Removed in 2003) Returned the specification for a function or command using a registration ID. |
| CEILING (CEILING.MATH) Returns the number rounded up to the nearest integer or significant figure. |
| 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. |
| COUNTIF (COUNTIFS) The number of numerical values that satisfies one condition. |
| DATEDIF Returns the number of days, months or years between two dates. |
| DATESTRING (Removed in 2003) Returned the system date in the MM-dd-yyyy format, using abbreviated month name. |
| ECMA.CEILING (CEILING.MATH) Returns the number rounded up to the nearest multiple of significance. |
| FALSE Returns the logical value False. |
| FLOOR (FLOOR.MATH) Returns the number rounded down to the nearest integer or significant figure. |
| 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) Returned 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. |
| REGISTER.ID (Removed in 2003) Returned the result after running an Excel 4.0 Macro function. |
| SINGLE (Removed in 365) Returned the value from a cell range which is the intersection of a row OR a column. |
| SQL.REQUEST (Removed in 2003) Returned the result after connecting to a data source and executes a SQL query. |
| SUBTOTAL (AGGREGATE) The subtotal of values in a list, table or cell range (renamed). |
| SUMIF (SUMIFS) The total of the numerical values that satisfies one condition. |
| 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). |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext