UNITS
Description
Returns the units part of a number as a string. If the number does not have a units
value, the function returns an empty string.
Syntax
UNITS(
value
)
- value: The number to return the unit of measurement for.
Example
Formula | Result |
|---|---|
=UNITS(A1) where the value in A1 currently has the "cup" unit) | cup |