PowerUp Description
The pwrCONVERTWEIGHT PowerUp function converts a number with a given unit to an equivalent number in another unit. Many common units are included ranging from milligrams to tons.
PowerUp Syntax
pwrCONVERTWEIGHT(value, SourceUnit, TargetUnit)
The pwrCONVERTWEIGHT PowerUp function has the following arguments:
value – Required. This is the number you will be converting.
SourceUnit – Required. This is a value that represents the source unit which are detailed below.
TargetUnit – Required. This is a value that represents the target unit to which the conversion will be done. Any combination of the argument values below can be used.
MCG – Microgram
G – Gram
KG – Kilogram
LB – Pound
TON – Ton
OZ – Ounce
MG – Milligram
CT – Carat
Return Value
pwrCONVERTWEIGHT will return an equivalent number of SourceUnit expressed in TargetUnit.
Remarks
For some of the very large or high precision numbers, the possibility for round off errors exists. Always verify the returned values.
Example
=pwrCONVERTWEIGHT(A1,"g","oz")