Excel 2007

birol_mumcu · 30 Kasım 2006

25.IMDIV
Returns the quotient of two complex numbers in x + yi or x + yj text format.

Syntax

IMDIV(inumber1,inumber2)

Inumber1 is the complex numerator or dividend.

Inumber2 is the complex denominator or divisor.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The quotient of two complex numbers is:

Example

=IMDIV("-238+240i","10+24i") Quotient of the two complex numbers in the formula (5 + 12i)

birol_mumcu · 30 Kasım 2006

26.IMEXP
Returns the exponential of a complex number in x + yi or x + yj text format.

Syntax

IMEXP(inumber)

Inumber is a complex number for which you want the exponential.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The exponential of a complex number is:

Example

=IMEXP("1+i") Exponential of the complex number 1+i (1.468694 + 2.287355i)

birol_mumcu · 30 Kasım 2006

27.IMLN
Returns the natural logarithm of a complex number in x + yi or x + yj text format.

Syntax

IMLN(inumber)

Inumber is a complex number for which you want the natural logarithm.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The natural logarithm of a complex number is:

Example

=IMLN("3+4i") Natural logarithm of 3+4i (1.609438 + 0.927295i)

birol_mumcu · 30 Kasım 2006

28.IMLOG10
Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

Syntax

IMLOG10(inumber)

Inumber is a complex number for which you want the common logarithm.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The common logarithm of a complex number can be calculated from the natural logarithm as follows:

Example

=IMLOG10("3+4i") Logarithm (base 10) of 3+4i (0.69897 + 0.402719i)

birol_mumcu · 30 Kasım 2006

29.IMLOG2
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.

Syntax

IMLOG2(inumber)

Inumber is a complex number for which you want the base-2 logarithm.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The base-2 logarithm of a complex number can be calculated from the natural logarithm as follows:

Example

=IMLOG2("3+4i") Base-2 logarithm of 3+4i (2.321928 + 1.337804i)

birol_mumcu · 30 Kasım 2006

30.IMPOWER
Returns a complex number in x + yi or x + yj text format raised to a power.

Syntax

IMPOWER(inumber,number)

Inumber is a complex number you want to raise to a power.

Number is the power to which you want to raise the complex number.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
If number is nonnumeric, IMPOWER returns the #VALUE! error value.
Number can be an integer, fractional, or negative.
A complex number raised to a power is calculated as follows:

where:

and:

and:

Example

=IMPOWER("2+3i", 3) 2+3i raised to the power of 3 (-46 + 9i)

birol_mumcu · 30 Kasım 2006

31.IMPRODUCT
Returns the product of 1 to 255 complex numbers in x + yi or x + yj text format.

Syntax

IMPRODUCT(inumber1,inumber2,...)

Inumber1, inumber2,… are 1 to 255 complex numbers to multiply.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The product of two complex numbers is:

Example

=IMPRODUCT("3+4i","5-3i") Product of the two complex numbers (27 + 11i)
=IMPRODUCT("1+2i",30) Product of a complex number and 30 (30 + 60i)

birol_mumcu · 30 Kasım 2006

32.IMREAL
Returns the real coefficient of a complex number in x + yi or x + yj text format.

Syntax

IMREAL(inumber)

Inumber is a complex number for which you want the real coefficient.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
Example

=IMREAL("6-9i") Real coefficient of 6-9i (6)

birol_mumcu · 30 Kasım 2006

33.IMSIN
Returns the sine of a complex number in x + yi or x + yj text format.

Syntax

IMSIN(inumber)

Inumber is a complex number for which you want the sine.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The sine of a complex number is:

Example

=IMSIN("3+4i") Sine of 3+4i (3.853738 - 27.016813i)

birol_mumcu · 30 Kasım 2006

34.IMSQRT
Returns the square root of a complex number in x + yi or x + yj text format.

Syntax

IMSQRT(inumber)

Inumber is a complex number for which you want the square root.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The square root of a complex number is:

Example

=IMSQRT("1+i") Square root of 1+i (1.098684 + 0.45509i)

birol_mumcu · 30 Kasım 2006

35.IMSUB
Returns the difference of two complex numbers in x + yi or x + yj text format.

Syntax

IMSUB(inumber1,inumber2)

Inumber1 is the complex number from which to subtract inumber2.

Inumber2 is the complex number to subtract from inumber1.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The difference of two complex numbers is:

Example

=IMSUB("13+4i","5+3i") Difference between the two complex numbers in the formula (8 + i)

birol_mumcu · 30 Kasım 2006

36.IMSUM
Returns the sum of two or more complex numbers in x + yi or x + yj text format.

Syntax

IMSUM(inumber1,inumber2,...)

Inumber1,inumber2,... are 1 to 255 complex numbers to add.

Remarks

Use COMPLEX to convert real and imaginary coefficients into a complex number.
The sum of two complex numbers is:

Example

=IMSUM("3+4i","5-3i") Sum of the two complex numbers in the formula (8+i)

birol_mumcu · 30 Kasım 2006

37.OCT2BIN
Converts an octal number to binary.

Syntax

OCT2BIN(number,places)

Number is the octal number you want to convert. Number may not contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Places is the number of characters to use. If places is omitted, OCT2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

Remarks

If number is negative, OCT2BIN ignores places and returns a 10-character binary number.
If number is negative, it cannot be less than 7777777000, and if number is positive, it cannot be greater than 777.
If number is not a valid octal number, OCT2BIN returns the #NUM! error value.
If OCT2BIN requires more than places characters, it returns the #NUM! error value.
If places is not an integer, it is truncated.
If places is nonnumeric, OCT2BIN returns the #VALUE! error value.
If places is negative, OCT2BIN returns the #NUM! error value.
Example

=OCT2BIN(3, 3) Converts octal 3 to binary with 3 characters (011)
=OCT2BIN(7777777000) Converts octal 7777777000 to binary (1000000000)

birol_mumcu · 30 Kasım 2006

38.OCT2DEC
Converts an octal number to decimal.

Syntax

OCT2DEC(number)

Number is the octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Remark

If number is not a valid octal number, OCT2DEC returns the #NUM! error value.

Example

=OCT2DEC(54) Converts octal 54 to decimal (44)
=OCT2DEC(7777777533) Converts octal 7777777533 to decimal (-165)

birol_mumcu · 30 Kasım 2006

39.OCT2HEX
Converts an octal number to hexadecimal.

Syntax

OCT2HEX(number,places)

Number is the octal number you want to convert. Number may not contain more than 10 octal characters (30 bits). The most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Places is the number of characters to use. If places is omitted, OCT2HEX uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

Remarks

If number is negative, OCT2HEX ignores places and returns a 10-character hexadecimal number.
If number is not a valid octal number, OCT2HEX returns the #NUM! error value.
If OCT2HEX requires more than places characters, it returns the #NUM! error value.
If places is not an integer, it is truncated.
If places is nonnumeric, OCT2HEX returns the #VALUE! error value.
If places is negative, OCT2HEX returns the #NUM! error value.
Example

=OCT2HEX(100, 4) Converts octal number 100 to hexadecimal with 4 characters (0040)
=OCT2HEX(7777777533) Converts octal number 7777777533 to hexadecimal (FFFFFFFF5B)

birol_mumcu · 30 Kasım 2006

these are new formulas in excel 2007. (all of the pages are taken to excel2007 help menu)
i didnt do any experiment for the formulas. be couse i dont use these.
if i find new news and things, i will attach this headline for you.

birol_mumcu · 3 Aralık 2006

What's new in Microsoft Office Excel 2007

hi friends;
there is an explanation for excel2007 in the lower line.
http://office.microsoft.com/en-us/excel/HA100738731033.aspx
may it be easy