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"
Kilo gram	"kg"
Slug	"sg"
Pound mass	"lbm"
U(atomic mass unit)	"u"
Ounce mass	"ozm"

Distance	Fu or Tu
Meter	"m"
Kilometer	"km"
Statute mile	"mi"
Nautical mile	"Nmi"
Inch	"in"
yard	"yd"
Foot	"ft"
Angstrom	"ang"
Pica(1/72 in.)	"Pica"

Time	Fu or Tu
Year	"yr"
Day	"day"
Hour	"hr"
Minute	"mn"
Second	"sec"

Pressure	Fu or Tu
Pascal	"Pa"
Atmosphere	"atm"
mm of Mercury	"mmHg"

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