Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / CONVERT
In This Topic
    CONVERT
    In This Topic

    This function converts a number from one measurement system to its equivalent in another measurement system.

    Syntax

    CONVERT(number,from-unit,to-unit)

    Arguments

    This function has these arguments:

    Argument Description
    number Numeric value to convert
    from-unit Convertible units (see table below) of numeric value to convert
    to-unit Convertible units (see table below) of desired result

    Remarks

    In this context a measurement system is a set of units for different types of measurements. This function converts a number with one set of units to a number in different set of units.

    An error value is returned if the convertible units (from-unit and to-unit) are invalid or are from different categories of unit types (different tables below).

    The following tables list the convertible units by their unit type:

    Weight and Mass Unit Type Convertible Units
    Gram "g"
    Slug "sg"
    Pound Mass "lbm"
    U "u"
    Ounce Mass "ozm"
    Distance Unit Type Convertible Units
    Meter "m"
    Statute mile "mi"
    Nautical mile "Nmi"
    Inch "in"
    Foot "ft"
    Yard "yd"
    Angstrom "ang"
    Pica (1/72 in.) "Pica"
    Time Unit Type Convertible Units
    Year "yr"
    Day "day"
    Hour "hr"
    Minute "mn"
    Second "sec"
    Pressure Unit Type Convertible Units
    Pascal "Pa"
    Atmosphere "atm"
    mm of Mercury "mmHg"
    Force Unit Type Convertible Units
    Newton "N"
    Dyne "dyn"
    Pound force "lbf"
    Energy Unit Type Convertible Units
    Joule "J"
    Erg "e"
    Thermodynamic calorie "c"
    IT calorie "cal"
    Electron volt "eV"
    Horsepower-hour "Hph"
    Watt-hour "Wh"
    Foot-pound "flb"
    BTU "BTU"
    Power Unit Type Convertible Units
    Horsepower "HP"
    Watt "W"
    Magnetism Unit Type Convertible Units
    Tesla "T"
    Gauss "ga"
    Temperature Unit Type Convertible Units
    Degree Celsius "C"
    Degree Fahrenheit "F"
    Degree Kelvin "K"
    Liquid Measure Unit Type Convertible Units
    Teaspoon "tsp"
    Tablespoon "tbs"
    Fluid ounce "oz"
    Cup "cup"
    U.S. pint "pt"
    U.K. pint "uk_pt"
    Quart "qt"
    Gallon "gal"
    Liter "l"

    Data Types

    Accepts numeric and string data. Returns numeric data.

    Examples

    CONVERT(68,"F","C")

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    OCT2BIN | HEX2DEC | DEC2OCT | Engineering Functions