Microsoft Excel

Microsoft Excel is a commonly used spreadsheet reference, so we provide focused comparisons to show how its formulas translate into alternative editors.

What you can do here

• Compare lookup, criteria, error-handling, array and text formulas with programs such as LibreOffice, Apple Numbers and Zoho Sheet.
• Follow the version notes and read the underlying vendor references rather than assuming that similarly named functions behave identically.
• Try the Formula Migration Helper and compatibility library with a common sample dataset.

Vendor documentation

Read the official documentation for product-specific features and arguments.

Before moving a workbook

Microsoft Excel has different function availability across Microsoft 365, Excel 2024, Excel 2021 and older releases. Compatibility examples should be verified against your version, including dynamic-array and regex functions.

Verification status: Official product documentation reviewed for this overview. Any listed formulas elsewhere on the site carry their own evidence status. No native tests in this product are claimed by this page, and no simulated application screenshots are presented.

Individual function guides

Our growing A–Z function directory has worked examples and review notes for selected documented functions. Absence of a guide does not prove a function is unsupported.