CONVERT
converts number between measurement units · from excel · excel: not yet compared · sheets: not yet compared
signature
CONVERT(number, from_unit, to_unit)
returns: number
| argument | required |
|---|---|
| number | required |
| from_unit | required |
| to_unit | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=CONVERT(100, "km", "mi") 62.13711922373339 errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #N/A | =CONVERT(1, 2, 2) |