Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The VALUE function returns the value of an element at a given index (indexes are zero-based).
Syntax
VALUE(array, index)
The VALUE function syntax has the following arguments:
- array: Required. The array from which you want to retrieve the value.
- index: Required. The zero-based index of the element you want to retrieve from the array.
Example
| Formula | Description | Result |
| =VALUE({1, 2, 3}, 1) | Returns the value at index 1 from the array {1, 2, 3}. | 2 |
| =VALUE({"apple", "banana", "cherry"}, 0) | Returns the value at index 0 from the array {"apple", "banana", "cherry"}. | apple |
Errors
For a full list of formula errors, please read Formula errors.