Formulas and Functions

Chapter 5 Engineering Functions 83
Metricprexes
Measure Constant Multiplier
exa “E” 1E+18
peta “P” 1E+15
tera “T” 1E+12
giga “G” 1E+09
mega “M” 1E+06
kilo “k” 1E+03
hecto “h” 1E+02
deca “e” 1E+01
deci “d” 1E-01
centi “c” 1E-02
milli “m” 1E-03
micro “u” or “µ” 1E-06
nano “n” 1E-09
pico “p” 1E-12
femto “f” 1E-15
atto “a” 1E-18
Usage Notes
These prexes can only be used with the metric constants “g”, “u”, “m”, “ang”, “sec”, “m/h”, Â
“m/mn”, “m/s”, “Pa”, “atm”, “mmHg”, “N”, “dyn”, “J”, “e”, “c”, “cal”, “eV”, “Wh”, “W”, “T”, “ga”, “K”, and “l”.
DEC2BIN
The DEC2BIN function converts a decimal number to the corresponding binary
number.
DEC2BIN(decimal-string, convert-length)
 decimal-string: The string representing the number to be converted. decimal-string
is a string value. It must contain only the numbers 0 through 9.
 convert-length: An optional value specifying minimum length of the number
returned. convert-length is a number value and must be in the range 1 to 32. If
omitted, it is assumed to be 1. If included, convert-string is padded with leading
zeros, if necessary, so that it is at least the length specied by convert-length.