IBM Lotus Symphony
|
IMABS , IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSIN , IMSUB, IMSUM, IMSQRT, COMPLEX, OCT2BIN, OCT2DEC , OCT2HEX, CONVERT_ADD, FACTDOUBLE.
IMABS(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMABS("5+12j") returns 13.
IMAGINARY(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMAGINARY("4+3j") returns 3.
IMPOWER(Complex number;Number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
Number: the exponent.
=IMPOWER("2+3i";2) returns -5+12i.
IMARGUMENT(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMARGUMENT("3+4j") returns 0.927295.
IMCOS(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMCOS("3+4j") returns -27.03-3.85i (rounded).
IMDIV(Numerator;Denominator)
Numerator, Denominator: the complex numbers are entered in the form "x + yi" or "x + yj"
=IMDIV("-238+240i";"10+24i") returns 5+12i.
IMEXP(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMEXP("1+j") returns 1.47+2.29j (rounded).
IMCONJUGATE(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMCONJUGATE("1+j") returns 1-j.
IMLN(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMLN("1+j") returns 0.35+0.79j (rounded).
IMLOG10(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMLOG10("1+j") returns 0.15+0.34j (rounded).
IMLOG2(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMLOG2("1+j") returns 0.50+1.13j (rounded).
IMPRODUCT(Complex number;Complex number 1;...)
Complex number: the complex numbers are entered in the form "x + yi" or "x + yj"
=IMPRODUCT("3+4j";"5-3j") returns 27+11j.
IMREAL(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMREAL("1+3j") returns 1.
IMSIN(Complex number)
Complex number: the complex number is entered in the form "x + yi" or "x + yj"
=IMSIN("3+4j") returns 3.85+27.02j (rounded).
IMSUB(Complex number 1;Complex number 2)
Complex number: the complex numbers are entered in the form "x + yi" or "x + yj"
=IMSUB("13+4j";"5+3j") returns 8+j.
IMSUM(Complex number 1;Complex number 2;...)
Complex number: the complex numbers are entered in the form "x + yi" or "x + yj"
=IMSUM("13+4j";"5+3j") returns 18+7j.
IMSQRT(Complex number)
Complex number: the complex numbers are entered in the form "x + yi" or "x + yj"
=IMSQRT("3+4i") returns 2+1i.
The result is a complex number which is returned from a real coefficient and an imaginary coefficient.
COMPLEX(Real num;I num;Suffix)
Real num: the real coefficient of the complex number.
I num: the imaginary coefficient of the complex number.
Suffix: list of options, "i" or "j".
=COMPLEX(3;4;"j") returns 3+4j.
OCT2BIN(Number;Places)
Number: 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: the number of places to be output.
=OCT2BIN(3;3) returns 011.
OCT2DEC(Number)
Number: 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(Number;Places)
Number: 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: the number of places to be output.
=OCT2HEX(144;4) returns 0064.
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 |
Length | m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec |
Time | yr, day, hr, mn, sec |
Pressure | Pa, atm, mmHg, Torr, psi |
Force | N, dyn, pond |
Energy | J, e, c, cal, eV, HPh, Wh, BTU |
Power | W, HP, PS |
Field strength | T, ga |
Temperature | C, F, K, Reau, Rank |
Volume | l, tsp, tbs, oz, cup, 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/h, mph, kn, admkn |
Each unit of measure must be preceded by a prefix character from the following list:
Permitted prefix characters | |
---|---|
10^(<0) | d, c, m, u, n, p, f, a, z, y |
10^(>0) | e, h, k, M, G, T, P, E, Z, Y |
CONVERT_ADD(Number;From unit;To unit)
Number: the number to be converted.
From unit: the unit from which conversion is taking place.
To unit: the unit to which conversion is taking place.
=CONVERT_ADD(10;"HP";"PS") returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS.
=CONVERT_ADD(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(Number)
Number: if the number is even, the following factorial is calculated: n*(N-2)*(n-4)*...*4*2.
If the number is uneven, the following factorial is calculated: n*(N-2)*(n-4)*...*3*1.
=FACTDOUBLE(6) returns 48.