Add-in Functions, List of Analysis Functions Part Two

+ +IMABS function + + +

IMABS

+ The result is the absolute value of a complex number. +

+ IMABS("ComplexNumber") + ComplexNumber is a complex number that is entered in the form "x+yi" or "x+yj". +no blanks allowed, see i82522 +

+ + =IMABS("5+12j") returns 13. +

+IMAGINARY function + + +

IMAGINARY

+ The result is the imaginary coefficient of a complex number. +

+ IMAGINARY("ComplexNumber") +

+ + =IMAGINARY("4+3j") returns 3. +

+IMPOWER function + + +

IMPOWER

+ The result is the ComplexNumber raised to the power of Number. +

+ IMPOWER("ComplexNumber"; Number) +

+ + Number is the exponent. +

+ + =IMPOWER("2+3i";2) returns -5+12i. +

+IMARGUMENT function + + +

IMARGUMENT

+ The result is the argument (the phi angle) of a complex number. +

+ IMARGUMENT("ComplexNumber") +

+ + =IMARGUMENT("3+4j") returns 0.927295. +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+IMDIV function + + +

IMDIV

+ The result is the division of two complex numbers. +

+ IMDIV("Numerator"; "Denominator") + + Numerator, Denominator are complex numbers that are entered in the form "x+yi" or "x+yj". +

+ + =IMDIV("-238+240i";"10+24i") returns 5+12i. +

+IMEXP function + + +

IMEXP

+ The result is the power of e and the complex number. The constant e has a value of approximately 2.71828182845904. +

+ IMEXP("ComplexNumber") +

+ + =IMEXP("1+j") returns 1.47+2.29j (rounded). +

+IMCONJUGATE function + + +

IMCONJUGATE

+ The result is the conjugated complex complement to a complex number. +

+ IMCONJUGATE("ComplexNumber") +

+ + =IMCONJUGATE("1+j") returns 1-j. +

+IMLN function + + +

IMLN

+ The result is the natural logarithm (to the base e) of a complex number. The constant e has a value of approximately 2.71828182845904. +

+ IMLN("ComplexNumber") +

+ + =IMLN("1+j") returns 0.35+0.79j (rounded). +

+IMLOG10 function + + +

IMLOG10

+ The result is the common logarithm (to the base 10) of a complex number. +

+ IMLOG10("ComplexNumber") +

+ + =IMLOG10("1+j") returns 0.15+0.34j (rounded). +

+IMLOG2 function + + +

IMLOG2

+ The result is the binary logarithm of a complex number. +

+ IMLOG2("ComplexNumber") +

+ + =IMLOG2("1+j") returns 0.50+1.13j (rounded). +

+IMPRODUCT function + + +

IMPRODUCT

+ The result is the product of a set of complex numbers. +

+ IMPRODUCT() +

+ + =IMPRODUCT("3+4j";"5-3j") returns 27+11j. +

+IMREAL function + + +

IMREAL

+ The result is the real coefficient of a complex number. +

+ IMREAL("ComplexNumber") +

+ + =IMREAL("1+3j") returns 1. +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+ +

+ + + +

+IMSUB function + + +

IMSUB

+ The result is the subtraction of two complex numbers. +

+ IMSUB("ComplexNumber1"; "ComplexNumber2") +

+ + =IMSUB("13+4j";"5+3j") returns 8+j. +

+IMSUM function + + +

IMSUM

+ The result is the sum of a set of complex numbers. +

+ IMSUM() +

+ + =IMSUM("13+4j";"5+3j") returns 18+7j. +

+IMSQRT function + + +

IMSQRT

+ The result is the square root of a complex number. +

+ IMSQRT("ComplexNumber") +

+ + =IMSQRT("3+4i") returns 2+1i. +

+COMPLEX function + + +

COMPLEX

+ The result is a complex number which is returned from a real coefficient and an imaginary coefficient. +

+ COMPLEX(RealNum; INum [; Suffix]) + + RealNum is the real coefficient of the complex number. + + INum is the imaginary coefficient of the complex number. + + Suffix is a list of options, "i" or "j". +

+ + =COMPLEX(3;4;"j") returns 3+4j. +

+OCT2BIN function + converting;octal numbers, into binary numbers +mw added one entry + +

OCT2BIN

+ The result is the binary number for the octal number entered. +

+ OCT2BIN(Number [; Places]) + + Number is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement. + + Places is the number of places to be output. +

+ + =OCT2BIN(3;3) returns 011. +

+OCT2DEC function + converting;octal numbers, into decimal numbers +mw added one entry + +

OCT2DEC

+ The result is the decimal number for the octal number entered. +

+ OCT2DEC(Number) + + Number is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement. +

+ + =OCT2DEC(144) returns 100. +

+OCT2HEX function + converting;octal numbers, into hexadecimal numbers +mw added one entry + +

OCT2HEX

+ The result is the hexadecimal number for the octal number entered. +

+ OCT2HEX(Number [; Places]) + + Number is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement. + + Places is the number of places to be output. +

+ + =OCT2HEX(144;4) returns 0064. +

+CONVERT function + + +

CONVERT

+ Converts a value from one unit of measure to the corresponding value in another unit of measure. Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l. + + + + Property + + + Units + + + + + Weight + + + g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight, brton + + + + + Length + + + m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec, lightyear, survey_mi + + + + + Time + + + yr, day, hr, mn, sec, s + + + + + Pressure + + + Pa, atm, at, mmHg, Torr, psi + + + + + Force + + + N, dyn, dy, lbf, pond + + + + + Energy + + + J, e, c, cal, eV, ev, HPh, Wh, wh, flb, BTU, btu + + + + + Power + + + W, w, HP, PS + + + + + Field strength + + + T, ga + + + + + Temperature + + + C, F, K, kel, Reau, Rank + + + + + Volume + + + l, L, lt, tsp, tbs, oz, cup, pt, us_pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass + + + + + Area + + + m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha + + + + + Speed + + + m/s, m/sec, m/h, mph, kn, admkn + + + + + Information + + + bit, byte + + +

+ + Units of measure in bold can be preceded by a prefix character from the following list: + + + + Prefix + + + Multiplier + + + + + Y (yotta) + + + 10^24 + + + + + Z (zetta) + + + 10^21 + + + + + E (exa) + + + 10^18 + + + + + P (peta) + + + 10^15 + + + + + T (tera) + + + 10^12 + + + + + G (giga) + + + 10^9 + + + + + M (mega) + + + 10^6 + + + + + k (kilo) + + + 10^3 + + + + + h (hecto) + + + 10^2 + + + + + e (deca) + + + 10^1 + + + + + d (deci) + + + 10^-1 + + + + + c (centi) + + + 10^-2 + + + + + m (milli) + + + 10^-3 + + + + + u (micro) + + + 10^-6 + + + + + n (nano) + + + 10^-9 + + + + + p (pico) + + + 10^-12 + + + + + f (femto) + + + 10^-15 + + + + + a (atto) + + + 10^-18 + + + + + z (zepto) + + + 10^-21 + + + + + y (yocto) + + + 10^-24 + + +

+ Information units "bit" and "byte" may also be prefixed by one of the following IEC 60027-2 / IEEE 1541 prefixes: + + + + ki kibi 1024 + Mi mebi 1048576 + Gi gibi 1073741824 + Ti tebi 1099511627776 + Pi pebi 1125899906842620 + Ei exbi 1152921504606850000 + Zi zebi 1180591620717410000000 + Yi yobi 1208925819614630000000000 + + +

+ CONVERT(Number; "FromUnit"; "ToUnit") + + Number is the number to be converted. + + FromUnit is the unit from which conversion is taking place. + + ToUnit is the unit to which conversion is taking place. Both units must be of the same type. +

+ + =CONVERT(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS. + + =CONVERT(10;"km";"mi") returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3. +

+FACTDOUBLE function + factorials;numbers with increments of two +mw added one entry + +

FACTDOUBLE

+ Returns the double factorial of a number. +

+ FACTDOUBLE(Number) + Returns Number + !!, the double factorial of Number, where Number is an integer greater than or equal to zero. + For even numbers FACTDOUBLE(n) returns: + 2*4*6*8* ... *n + For odd numbers FACTDOUBLE(n) returns: + 1*3*5*7* ... *n + FACTDOUBLE(0) returns 1 by definition. +

+ + =FACTDOUBLE(5) returns 15. + + =FACTDOUBLE(6) returns 48. + + =FACTDOUBLE(0) returns 1.see also FACT, MULTINOMIAL, PRODUCT +