Engineering Functions
BIN2DEC
Returns the decimal value of a string representation of a number in a binary system.
Bin2Dec(number)
Number is a string representing a binary number.
BIN2HEX
Converts a string representing a binary number to a string representing the same number in the hexadecimal number system.
Bin2Hex (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the mimumum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
BIN2OCT
Converts a string representing a binary number to a string representing the same number in the octal number system.
Bin2Oct (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the mimumum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
COMPLEX
Returns a complex number represented as a string in the format “x + yi” or “x + yj” by comining a real and imaginary number.
COMPLEX (realNumber, imaginaryNumber, [suffix])
RealNumber is the real coefficient of the complex number.
ImaginaryNumber is the imaginary coefficient of the number.
Suffix specifies the suffix to use. The acceptable values are “i” or “j”. If omitted, “i” is used. Note that the suffix is case-sensitive; upper case “I” and “J” are not allowed and will result in a #VALUE error.
CONVERT
Converts a value from one system of measurement to another. For example, meters to inches or hours to seconds.
CONVERT (number, fromUnit, toUnit)
Number is the value to convert.
FromUnit is the unit in which the number is given.
ToUnit is the units to convert to.
Weight and mass units: “g” = gram “sg” = slug “lbm” = pound mass (avoirdupois) “u” = U (atomic mass unit) “ozm” = Ounce mass (avoirdupois)
Distance units: “m” = Meter “mi” = Statute mile “Nmi” = Nautical mile “in” = Inch “ft” = Foot “yd” = Yard “ang” = Angstrom “Pica” = Pica (1/72 in.)
Time units: “yr” = Year “day” = Day “hr” = Hour “mn” = Minute “sec” = Second
Pressure units “Pa” (or “p”) = Pascal “atm” (or “at”) = Atmosphere “mmHg” = mm of Mercury
Force units “N” = Newton “dyn” (or “dy”) = Dyne “lbf” = Pound force
Energy units: “J” = Joule “e” = Erg “c” = Thermodynamic calorie “cal” = IT calorie “eV” (or “ev”) = Electron volt “HPh” (or “hh”) = Horsepower-hour “Wh” (or “wh”) = Watt-hour “flb” = Foot-pound “BTU” (or “btu”) = BTU
Power units: “HP” (or “h”) = Horsepower “W” (or “w”) = Watt
Magentism units: “T” = Tesla “ga” = Gauss Temperature units: “C” (or “cel”) = Degree Celsius “F” (or “fah”) = Degree Fahrenheit “K” (or “kel”) = Kelvin
Liquid measure units: “tsp” = Teaspoon “tbs” = Tablespoon “oz” = Fluid ounce “cup” = Cup “pt” (or “us_pt”) = U.S. pint “uk_pt” = U.K. pint “qt” = Quart “gal” = Gallon “l” (or “lt”) = Liter
Any metric ToUnit or FromUnit may be prefixed with one of the following: 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 dekao (“e”) = 1E+01 deci (“d”) = 1E-01 centi (“c”) = 1E-02 milli (“m”) = 1E-03 micro (“u”) = 1E-06 nano (“n”) = 1E-09 pico (“p”) = 1E-12 femto (“f”) = 1E-15 atto (“a”) = 1E-18
DEC2BIN
Returns a string representing the specified decimal value as a binary number.
Dec2Bin (number, places)
Number is the decimal value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
DEC2HEX
Returns a string representing the specified decimal value as a hexadecimal number.
Dec2Hex (number, places)
Number is the decimal value to be converted.
Places is the number of characters to use in representing the value. If places is not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
DEC2OCT
Returns a string representing the specified decimal value as an octal number.
Dec2Oct (number, places)
Number is the decimal value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
DELTA
Compares two numbers and returns 1 if they are equal or 0 if they are not.
DELTA (number1, [number2])
Number1 is a number.
Number2 is a number. If Number2 is not specified, Number1 will be compared to 0.
GESTEP
Compares two numbers and returns 1 the first number is greater than or equal to the second or returns 0 if not.
GESTEP (number, [step])
Number is a number.
Step is a number. If step is not specified, Number will be compared to 0.
HEX2BIN
Converts a string representing a hexadecimal number to a string representing the same number in the binary number system.
Hex2Bin (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
HEX2DEC
Returns the decimal value of a string representation of a number in a hexadecimal system.
Hex2Dec(number)
Number is a string representing a hexadecimal number.
HEX2OCT
Converts a string representing a hexadecimal number to a string representing the same number in the octal number system.
Hex2Oct (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
IMABS
Returns the absolute value of a complex number.
IMABS(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMAGINARY
Returns the imaginary coefficient of a complex number.
IMAGINARY(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMARGUMENT
Returns the argument theta, and angle expressed in radians.
IMARGUMENT(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMCONJUGATE
Returns the conjugate of a complex number.
IMCONJUGATE(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMCOS
Returns the cosine of a complex number.
IMCOS(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMDIV
Returns the quotient of two complex numbers.
IMDIV (dividend, divisor)
Dividend is a complex number in the format: “x + yi” or “x + yj”.
Divisor is a complex number in the format: “x + yi” or “x + yj”.
IMEXP
Returns the exponential of a complex number.
IMEXP(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMLN
Returns the natural logarithm of a complex number.
IMLN(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMLOG10
Returns the base-10 logarithm of a complex number.
IMLOG10(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMLOG2
Returns the base-2 logarithm of a complex number.
IMLOG2(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMPOWER
Returns the complex number raised to the specified power.
IMPOWER (complexNumber, power)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
Power is the power to which ComplexNumber will be raised.
IMPRODUCT
Returns the product of 1 to n complex numbers.
IMPRODUCT (complexNumber1 [, complexNumber2, complexNumber3, …, complexNumberN])
ComplexNumber1, ComplexNumber2, …, ComplexNumberN is any number of complex numbers in the format: “x + yi” or “x + yj” which will be multiplied together.
IMREAL
Returns the real coefficient of a complex number.
IMREAL(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMSIN
Returns the sine of a complex number.
IMSIN(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMSQRT
Returns the square root of a complex number.
IMSQRT(complexNumber)
ComplexNumber is a complex number in the format: “x + yi” or “x + yj”.
IMSUB
Returns the difference between two complex numbers.
IMSUB (complexNumber1, complexNumber2)
ComplexNumber1 is a complex number in the format: “x + yi” or “x + yj” from which ComplexNumber2 will be subtracted.
ComplexNumber2 is a complex number in the format: “x + yi” or “x + yj” which will be subtracted from ComplexNumber1.
IMSUM
Returns the sum of 1 to n complex numbers.
IMSUM (complexNumber1 [, complexNumber2, complexNumber3, …, complexNumberN])
ComplexNumber1, ComplexNumber2, …, ComplexNumberN is any number of complex numbers in the format: “x + yi” or “x + yj” which will be added together.
OCT2BIN
Converts a string representing an octal number to a string representing the same number in the binary number system.
Oct2Bin (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.
OCT2DEC
Returns the decimal value of a string representation of a number in an octal system.
Oct2Dec(number)
Number is a string representing an octal number.
OCT2HEX
Converts a string representing an octal number to a string representing the same number in the hexadecimal number system.
Oct2Hex (number, places)
Number is the value to be converted.
Places is the number of characters to use in representing the value. If places are not specified, the minimum number of characters necessary to represent the value will be used. Places allows you to specify leading zeros.