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

argumentrequired
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.

errorproduced by
#N/A =CONVERT(1, 2, 2)

related

  • BESSELI returns modified Bessel function In(x)
  • BESSELJ returns Bessel function Jn(x)
  • BESSELK returns modified Bessel function Kn(x)
  • BESSELY returns Bessel function Yn(x)
  • BIN2DEC converts binary number to decimal
  • BIN2HEX converts binary number to hexadecimal