value
Returns the value in a table cell or single-value list.
This function is typically used in combination with cell or cellInRegion. This is because cell and cellInRegion return a table region (a single cell object) rather than the value in the cell. To get the cell's value, use value.
The difference between getting the cell object and getting the cell value doesn't appear to matter when you preview, but it may matter if you try to input the result to another function. See the examples.
Parameters
X (cell or list)
The cell or list to extract the value from. Must contain a single value.
Examples
Assume a "Describe the Table" project with this data:
Branch | Manager | Sales | COGS | otherExp | Profit | |
|---|---|---|---|---|---|---|
Row 1 | Aberdeen | Andrew Gray | 14,000 | 8,000 | 1,500 | 4,500 |
Row 2 | Edinburgh | Emma Moore | 33,000 | 19,000 | 3,500 | 10,500 |
Row 3 | Inverness | Linda Barclay | 16,000 | 8,250 | 1,500 | 6,250 |
Row 4 | Glasgow | Louise Scott | 33,500 | 17,750 | 1,700 | 13,050 |
The function is typically used in combination with the cell and len functions:
ATL in Script | Result |
|---|---|
| 1 |
| 10 |
In the first example, len returns the length of the cell object (one cell). In the second, len returns the length of the value in the cell. Note that 'Emma Moore' has 10 characters, including the blank space.
