PipeDream 4 — Spreadsheet Functions

PipeDream 4 provides many standard speadsheet functions to help you to perform calculations within number cells. Most functions take parameters, i.e. they perform calculations on numbers, dates, strings, etc., which you specify.

The following is a brief list of all PipeDream 4’s standard speadsheet functions. For a detailed description of any individual function, refer to the relevant section below. Fuller details may be available for certain complicated functions in the Reference Guide.

Database Functions

Date and Time Functions

Financial Functions

Lookup and Reference Functions

Mathematical Functions

Matrix Functions

Miscellaneous Functions

Statistical Functions

String Functions

Trigonometrical Functions

Complex Number Functions

PipeDream 4 also enables you to create your own functions. See Custom Functions.