Functions

CONVERT

Converts a number from one unit of measurement to another

Try it

When to use it

When should I use CONVERT?

Use CONVERT to translate a measurement from one unit to another, such as grams to kilograms or miles to kilometers, without manual conversion factors.

Used in

operations

Syntax

CONVERT(value,from_unit,to_unit)

Examples

=CONVERT(1000,"g","kg") // => 1
=CONVERT(1,"mi","km") // => 1.609344
=CONVERT(0,"C","F") // => 32

CONFIDENCE.T

Confidence interval half-width (t-dist)

CORREL

Pearson correlation coefficient