Contents

# Add-in Functions, List of Analysis Functions Part Two

The Add-in functions are supplied by the UNO com.sun.star.sheet.addin.Analysis service.

若要使用此指令...

[插入] – [函式] - [分類] [Add-In]

## [text/scalc/01/func_imcos.xhp#imcos_head not found].

Returns the cosine of a complex number.

## [text/scalc/01/func_imcosh.xhp#imcosh_head not found].

Returns the hyperbolic cosine of a complex number.

## [text/scalc/01/func_imcot.xhp#imcot_head not found].

Returns the cotangent of a complex number.

## [text/scalc/01/func_imcsc.xhp#imcsc_head not found].

Returns the cosecant of a complex number.

## [text/scalc/01/func_imcsch.xhp#imcsch_head not found].

Returns the hyperbolic cosecant of a complex number.

## [text/scalc/01/func_imsec.xhp#imsec_head not found].

Returns the secant of a complex number.

## [text/scalc/01/func_imsech.xhp#imsech_head not found].

Returns the hyperbolic secant of a complex number.

## [text/scalc/01/func_imsin.xhp#imsin_head not found].

Returns the sine of a complex number.

## [text/scalc/01/func_imsinh.xhp#imsinh_head not found].

Returns the hyperbolic sine of a complex number.

## IMTAN

Returns the tangent of a complex number.

## CONVERT

Converts a value from one unit of measurement to the corresponding value in another unit of measurement.

## COMPLEX

結果為從實際係數與虛係數傳回的複數。

#### Syntax

COMPLEX(RealNum; INum [; Suffix])

RealNum 是指複數的實數係數。

INum 是指複數的虛數係數。

Suffix 是選項的清單，「i」或「j」。

#### Example

=COMPLEX(3;4;"j") 傳回 3+4j。

## FACTDOUBLE

得出一個數的雙階乘。

#### Syntax

FACTDOUBLE(number)

傳回 Number !!，此為 Number 的雙階乘，其中 Number 是大於或等於零的整數。

若是偶數，FACTDOUBLE(n) 會得出：

2*4*6*8* ... *n

若是奇數，FACTDOUBLE(n) 會得出：

1*3*5*7* ... *n

FACTDOUBLE(0) 按定義得出 1。

#### Example

=FACTDOUBLE(5) 傳回 15。

=FACTDOUBLE(6) 傳回 48。

=FACTDOUBLE(0) 傳回 1。

## IMABS

結果為複數的絕對值。

#### Syntax

IMABS("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMABS("5+12j") 傳回 13。

## IMAGINARY

結果為複數的虛係數。

#### Syntax

IMAGINARY("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMAGINARY("4+3j") 傳回 3。

## IMARGUMENT

結果為複數的引數 (phi 角度)。

#### Syntax

IMARGUMENT("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMARGUMENT("3+4j") 傳回 0.927295。

## IMCONJUGATE

結果為一個複數的共軛補數。

#### Syntax

IMCONJUGATE("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMCONJUGATE("1+j") 傳回 1-j。

## IMDIV

結果為兩個複數的除法。

#### Syntax

IMDIV("Numerator"; "Denominator")

Numerator、Denominator 是以格式「x+yi」或「x+yj」輸入的複數。

#### Example

=IMDIV("-238+240i";"10+24i") 傳回 5+12i。

## IMEXP

結果為 e 與複數的乘冪。常數 e 的近似值為 2.71828182845904。

#### Syntax

IMEXP("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMEXP("1+j") 傳回 1.47+2.29j (四捨五入)。

## IMLN

結果為複數的自然對數 (以 e 為底數)。常數 e 的近似值為 2.71828182845904。

#### Syntax

IMLN("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMLN("1+j") 傳回 0.35+0.79j (四捨五入)。

## IMLOG10

結果為複數的常用對數 (以 10 為底數)。

#### Syntax

IMLOG10("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMLOG10("1+j") 傳回 0.15+0.34j (四捨五入)。

## IMLOG2

結果為複數以二為底的對數。

#### Syntax

IMLOG2("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMLOG2("1+j") 傳回 0.50+1.13j (四捨五入)。

## IMPOWER

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

#### Syntax

IMPOWER("ComplexNumber"; Number)

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

Number 是指數。

#### Example

=IMPOWER("2+3i";2) 傳回 -5+12i。

## IMPRODUCT

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

#### Syntax

IMPRODUCT(Complex 1 [; Complex 2 [; … [; Complex 255]]])

Complex 1, Complex 2, … ,Complex 255 are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj".

#### Example

=IMPRODUCT("3+4j";"5-3j") 傳回 27+11j。

## IMREAL

結果為複數的實際係數。

#### Syntax

IMREAL("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMREAL("1+3j") 傳回 1。

## IMSQRT

結果為複數的平方根。

#### Syntax

IMSQRT("ComplexNumber")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMSQRT("3+4i") 傳回 2+1i。

## IMSUB

結果為兩個複數相減。

#### Syntax

IMSUB("ComplexNumber1"; "ComplexNumber2")

ComplexNumber 是以「x+yi」或「x+yj」格式輸入的複數。

#### Example

=IMSUB("13+4j";"5+3j") 傳回 8+j。

## IMSUM

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

#### Syntax

IMSUM(Complex 1 [; Complex 2 [; … [; Complex 255]]])

Complex 1, Complex 2, … ,Complex 255 are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj".

#### Example

=IMSUM("13+4j";"5+3j") 傳回 18+7j。

## OCT2BIN

The result is the string representing the number in binary (base-2) form for the octal number string entered.

#### Syntax

OCT2BIN(Number [; Places])

Number is a string that represents an octal number. It 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 是指要輸出的位數。

#### Example

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

## OCT2DEC

The result is the number for the octal number string entered.

#### Syntax

OCT2DEC(number)

Number is a string that represents an octal number. It 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.

#### Example

=OCT2DEC("144") returns 100.

## OCT2HEX

The result is the string representing the number in hexadecimal form for the octal number string entered.

#### Syntax

OCT2HEX(Number [; Places])

Number is a string that represents an octal number. It 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 是指要輸出的位數。

#### Example

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

相關主題

Add-in Functions

Add-in Functions, List of Analysis Functions Part One

Statistics Functions

Functions by Category