Syntax
=CONVERT(number, from_unit, to_unit)Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The value to convert |
from_unit | Required | The unit of the number, like "ft", "kg" or "F" |
to_unit | Required | The unit to convert to |
How to use CONVERT
CONVERT takes 3 required arguments. Type =CONVERT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=CONVERT(1, "lbm", "kg")Result =CONVERT(68, "F", "C")Result =CONVERT(2.5, "ft", "sec")Result Related engineering functions
- BITORReturns the bitwise OR of two numbers.
- BITRSHIFTReturns a number shifted right by a number of bits (divided by a power of 2, rounded down).
- BITXORReturns the bitwise exclusive OR of two numbers.
- COMPLEXBuilds a complex number as text from its real and imaginary parts.
- DEC2BINConverts a decimal number to binary.
- DEC2HEXConverts a decimal number to hexadecimal.
- DEC2OCTConverts a decimal number to octal.
- DELTAReturns 1 when two numbers are equal and 0 otherwise.
- ERFReturns the error function integrated between zero (or a lower limit) and an upper limit.