The following Microsoft Excel functions have no equivalents in Lotus 1-2-3 Release 3.1 or earlier, or in Lotus 1-2-3 for Windows Release 1.0. If you save a workbook in one of these formats, these functions are replaced with the resulting value of the function.
Note This list does not include many Microsoft Excel add-in functions and statistical functions that do not have Lotus 1-2-3 equivalents.
| Microsoft Excel function |
|---|
| AREAS |
| DOLLAR |
| DPRODUCT |
| FACT |
| FREQUENCY |
| GETPIVOTDATA |
| GROWTH |
| INT |
| HYPERLINK |
| IPMT |
| ISBLANK |
| ISERROR |
| ISLOGICAL |
| LINEST |
| LOGEST |
| LOOKUP |
| MATCH |
| MDETERM |
| MINVERSE |
| MIRR |
| MMULT |
| PPMT |
| PRODUCT |
| SEARCH |
| SUBSTITUTE |
| TEXT |
| TRANSPOSE |
| TREND |
| TYPE |
| WEEKDAY |