The pwrCONVERTDISTANCE PowerUp function converts a number with a given unit to an equivalent number in another unit. Many common units are included. Also included are Light Years.
pwrCONVERTDISTANCE(value, SourceUnit, TargetUnit)
The pwrCONVERTDISTANCE 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.
CM – centimeters
FT – feet
IN – inches
KM – kilometers
LY – light years
M – meters
MI – mile
MM – millimeters
MU – microns
NM – nautical mile
YD – yards
pwrCONVERTDISTANCE will return an equivalent number of SourceUnit expressed in TargetUnit.
For some of the very large or high precision numbers, the possibility for round off errors exists. Always verify the returned values.