4D View Pro Formulas

Home

4D v17

Overview

4D View Pro functions are used in formulas. Every 4D View Pro formula is an expression that returns a value. All expressions are comprised of operands and operators:

Operators: see Operators and values
Operands are divided into several categories:
- values,
- references to other cells (relatives, absolutes, mixed or by name),
- 4D variables, fields and functions,
- 4D View Pro functions.

To enter a formula:

Select the cell into which you will enter the formula or function.
Enter = (the equal sign).
Type in the formula then hit the Enter key

A very large number of functions are available in 4D View Pro. This section proposes a subset of essential functions. The whole list of functions supported by 4D View Pro can be found in the Spreadsheets documentation.

Operators and values