SETUNITS
Description
Converts a number from its current unit of measurement to another. This function is
similar to CONVERT(), but in CONVERT() you must specify both the original and the
new units value.
Syntax
SETUNITS(
value
,
set_unit
)
- value: The number to convert.
- set_unit: The units to return the value in. Theset_unitargument is case-sensitive.
Example
Formula | Result |
|---|---|
=SETUNITS(825,"cup") where 825 currently has the "tsp" unit | 17.185 |
=SETUNITS(98.6,"cel") where 98.6 currently has the "F" unit | 37 |
Notes
- Valid units values are from the base library javax.measure.unit.Dimension.