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