# 邏輯函式

This category contains the Logical functions.

### Handling non-logical arguments in logical functions

• Zero (0) is equivalent to FALSE and all other numbers are equivalent to TRUE.

• Empty cells and text in cells are ignored.

• A #VALUE error is raised if all arguments are ignored.

• A #VALUE error is raised if one argument is direct text (not text in a cell).

• Errors as argument lead to an error.

[插入] - [函式] - [類別] [邏輯]

## AND

### 語法

AND(LogicalValue1; LogicalValue2 ...LogicalValue30)

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range. The result is TRUE if the logical value in all cells within the cell range is TRUE.

### 範例

=AND(12<13;14>12;7<6) 傳回 FALSE。

=AND (FALSE;TRUE) 傳回 FALSE。

## FALSE

FALSE()

### 範例

=FALSE() 傳回 FALSE。

=NOT(FALSE()) 傳回 TRUE。

## IF

### 語法

IF(Test; ThenValue; OtherwiseValue)

Test 是任意值或可為 TRUE 或 FALSE 的表示式。

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

### 範例

=IF(A1>5;100;"太小") 若 A1 中的值大於 5，就會在目前的儲存格中輸入值 100；否則，會輸入文字「太小」(不包括角括號)。

## NOT

### 語法

NOT(LogicalValue)

LogicalValue 是要反轉的值。

### 範例

=NOT(A)。若 A=TRUE，則 NOT(A) 將評估 FALSE。

## OR

### 語法

OR(LogicalValue1; LogicalValue2 ...LogicalValue30)

LogicalValue1; LogicalValue2 ...LogicalValue30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses all values of the range.

### 範例

=OR(12<11;13>22;45=45) 傳回 TRUE。

=OR(FALSE;TRUE) 傳回 TRUE。

## TRUE

TRUE()

### 範例

=AND(A;B) 傳回 FALSE。

=OR(A;B) 傳回 TRUE。

=NOT(AND(A;B)) 傳回 TRUE。

## XOR

Returns true if an odd number of arguments evaluates to TRUE.

### 語法

OR(LogicalValue1; LogicalValue2 ...LogicalValue30)

### 範例

=AND (FALSE;TRUE) 傳回 FALSE。

=OR(FALSE;TRUE) 傳回 TRUE。

=OR(FALSE;TRUE) 傳回 TRUE。