DIMENSIONS
Description
Returns the dimension of a numeric value. If there are no dimensions, the function
returns an empty string. If the argument is not numeric, the function returns a
#VALUE error.
A dimension is a property that can be measured, such as time (T), length (L), or mass
(M). A unit is a value of a dimension; for example, seconds (sec) or meters (m).
Syntax
DIMENSIONS(
value
)
- value: The value to return the dimension for.
Example
Formula | Result |
|---|---|
=DIMENSIONS(50) where 50 currently has the "m" (meters) unit | L |
Notes
- Valid dimension values are from the base library javax.measure.unit.Dimension.
- This function is similar to UNITS(), but UNITS() returns the unit value instead of the dimension value.