FORMULA LANGUAGE


@Elements
Example

Calculates the number of text, number, or time­date values in a list. This function always returns a number to indicate the number of entries in the list.

Syntax

@Elements( list )

Parameters

list


Return value

numElements


Usage

You can use @Elements in the condition statement of @For functions to set the loop count equal to the number of elements in the list:

@For(n := 1; n <= @Elements(list); n := n + 1;formula)

Example
See Also