Advanced Excel Functions 简明教程

Advanced Excel - Logical Functions

逻辑函数包括布尔运算符和条件测试，它们是许多工作电子表格的重要组成部分。

Logical functions include the boolean operators and conditional tests, which will be an essential part of many working spreadsheets.

Logical Functions

下表列出了所有逻辑函数 −

The following table lists all the Logical functions −

S.No.

Function and Description

1

ANDReturns TRUE if all its arguments are TRUE.

2

FALSEReturns the logical value FALSE.

3

IFSpecifies a logical test to perform.

4

IFERRORReturns a different result if the first argument evaluates to an error.

5

IFNAReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

6

IFSChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

7

NOTReverses the logic of its argument.

8

ORReturns TRUE if any argument is TRUE.

9

SWITCHEvaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

10

TRUEReturns the logical value TRUE.

11

XORReturns a logical exclusive OR of all arguments.