Formula Reference

The dataspace supports over 500 Excel-style formulas across the categories you already know. This page lists them by category so you can look a name up before writing a formula; in daily use you rarely need it - type = followed by a few letters and matching functions appear as you type, with their arguments.

Anything you already wrote for Excel or WPS Spreadsheets carries over as-is, including ranges such as A1:A10 and custom names. A custom name cannot contain a space or square brackets, so give that column a name without spaces - Order_ID rather than Order ID.

Because the functions follow Excel conventions, Microsoft's function reference works as documentation for anything you need in more detail. Return to Dataspace to see how formulas are used in practice.

1. Financial Functions

See the category list above for the functions in this family.

2. Date and Time Functions

See the category list above for the functions in this family.

3. Mathematical and Trigonometric Functions

See the category list above for the functions in this family.

4. Statistical Functions

See the category list above for the functions in this family.

5. Lookup and Reference Functions

See the category list above for the functions in this family.

6. Database Functions

The D-prefixed family: DSUM, DAVERAGE, DCOUNT, DGET and the rest. They read a criteria area the same way Excel does.

7. Text Functions

See the category list above for the functions in this family.

8. Add-in and Automation Functions

Functions that reach outside the workbook, such as CALL and EUROCONVERT.

9. Logical Functions

See the category list above for the functions in this family.

10. Information Functions

Tests and diagnostics: ISERROR, ISBLANK, CELL, ERROR_TYPE and their siblings.

11. Engineering Functions

Statistical and special functions for engineering work, for example the BESSEL* family.

12. Compatibility Functions

Legacy names kept so older workbooks still calculate, such as BETADIST and BETAINV.

13. Web Functions

ENCODEURL and FILTERXML.

14. Specific to a Platform Functions

Newer dynamic-array helpers that Excel exposes per platform, for example ARRAY_CONSTRAIN and FLATTEN.

Dataspace - how formulas are used in practice
Data Management - importing and cleaning data
FAQ - errors and troubleshooting