MSOfficeExcel 2007 Tutorial Logical Functions 20 codes

1 =AND(1A2, A2100)

2 =AND(2+2=4, 2+3=5)

3 =IF(A1A2, A1, A2)

4 =IF(A1A2, Good!, Bad!)

5 =IF(A2=100,SUM(B5

6 =IF(A289,A,IF(A279,B, IF(A269,C,IF(A259,D,F))))

7 =IF(AND(1A3, A3100), A3, The value is out of range )

8 =NOT(1+1=2)

9 =OR(1+1=1,2+2=5)

10 =OR(TRUE,FALSE,TRUE)

11 AND(logical1,logical2, ) returns TRUE if all of its arguments are TRUE

12 Combine IF, AND and CHOOSE to display month name

13 Combine IF, OR and CHOOSE to display month name

14 FALSE() returns the logical value FALSE

15 IF(logical_test,value_if_true,value_if_false) specifies a logical test

16 IFERROR(value,value_if_error) returns a value in case of an error; otherwise, returns the result of the formula

17 Making an Error Behave the Way You Want

18 NOT(logical) reverses the logic of its argument

19 OR(logical1,logical2, ) returns TRUE if any argument is TRUE

20 TRUE( ) returns the logical value TRUE