# 公式

Go to Table - Edit Formula.

In the Table toolbar, press the Insert or Edit Formula icon.

In a text document, press F2.

## 公式选项摘要

### 基本计算函数

Operation

Name

Example

+

-

Calculates the difference.

MUL 或 *

Example: 7 MUL 9 displays 63

DIV或/

Calculates the quotient.

Example: 100 DIV 15 displays 6.67

### 子菜单中的基本函数

Function

Name

Example

SUM

ROUND

PHD

Calculates a percentage.

SQRT

Example: SQRT 25 displays 5

POW

Example: 2 POW 8 displays 256

### 运算符

You can insert various operators in your formula. Choose from the following functions:

Operator

Name

Example

|

MIN 10|20|50|<C6>|<A2:B6>|20

EQ 或 ==

Example: <A1> EQ 2 displays 1, if the content of A1 equals 2

NEQ 或 !=

Example: <A1> NEQ 2 displays 0 (wrong), if the content of A1 equals 2

LEQ

Example: <A1> LEQ 2 displays 1 (true), if the content of A1 is less than or equal to 2

GEQ

Tests for values greater than or equal to a specified value.

Example: <A1> GEQ 2 displays 1 (true), if the content of A1 is greater than or equal to 2

L

Tests for values less than a specified value.

Example: <A1> L 2 displays 1 (true), if the content of A1 is less than 2

G

Tests for values greater than a specified value.

Example: <A1> G 2 displays 1 (true), if the content of A1 is greater than 2

OR

Tests for values matching the Boolean OR.

XOR

Tests for values matching the Boolean exclusive OR.

AND

Tests for values matching the Boolean AND.

NOT

Tests for values matching the Boolean NOT.

### 统计函数

You can choose from the following statistical functions:

Function

Name

Example

Mean

MEAN

MIN

MAX

Example: MAX 10|30|20 displays 30

Product

PRODUCT

Calculates the product of the selected cells.

Example: PRODUCT <A2:C2> displays the product of the values in cells A2 to C2

Count

COUNT

Counts the number of non empty cells.

Example: COUNT <A2:C2> displays the number of non empty cells in A2 to C2

### Functions

You can choose from the following functions:

Function

Name

Example

SIN

Example: SIN (PI/2) displays 1

COS

Example: COS 1 displays 0.54

TAN

ASIN

ACOS

ATAN

Absolute value

ABS

Returns the absolute value of the number.

Example: ABS -34 returns 34

Sign

SIGN

Returns the algebraic sign of the number.

Example: SIGN -23 returns -1

Name

Description

CHAR

WORD

PARA

GRAPH

TABLES

OLE

PAGE

Description

Name

Value

PI

PI

3.1415...

E

2.71828...

TRUE

FALSE

0