Manuals/calci/CONVERT

CONVERT(n,fu,tu)

• $n$ is the value in $fu$.
• $fu$ is the units for the value.
• $tu$is the units for the result.

Description

This function gives the changing the one unit system to other unit system. Example:To change the length in kilometer unit to standard unit meter, Here N is the value to which we want to covert from FU to TU. Also FU and TU will accept any units which we need to give in " "(double quotes).

Weight/Mass	Fu or Tu
Gram	"g"
Slug	row 2, cell 3
"kg"	"sg"
Pound mass	row 2, cell 3
U(atomic mass unit)	"u"
Ounce mass)	"ozm"

Examples

Equation	n1	n2	n3	SUM
SUM(1,2,3)	1	2	3	6
SUM(5,-9,45)	5	-9	45	41
SUM(A1:A3)	CELL A1	CELL A2	CELL A3	A1+A2+A3

See also

• AVERAGE
• PRODUCT

References

SUM

CONVERT

Where 'N' is the value in 'FU” to convert, 'FU' is the units for number and 'TU' is the units for the result.

• CONVERT shows an error value when input data are incorrect.
• Unit must be there in this function, otherwise it shows an error value.
• Whenever the units are in different groups, CONVERT shows error value.

CONVERT

Lets see an example

CONVERT(N, FU,TU)

=CONVERT(1.50, "lbm", "kg") is 0.6804

=CONVERT(2.5, "ft", "sec") shows NAN(error) value. Syntax Remarks Examples Description This function converts a number from one measurement system to another system.

	Column1	Column2	Column3	Column4
Row1	0.6804	NaN
Row2
Row3
Row4
Row5
Row6