100 Nos Of Formula and Functions
In MSExcel
Part 2
21-40: Logical Functions
21. IF - Tests a condition
and returns a value if true or false.
o Example: =IF(A1 > 10,
"Yes", "No")
For Detail --->Click here
22. AND - Returns TRUE if all
conditions are met.
o Example: =AND(A1 > 5,
B1 < 10)
For Detail --->Click here
23. OR - Returns TRUE if any
condition is met.
o Example: =OR(A1 > 5, B1
< 10)
For Detail --->Click here
24. NOT - Reverses the logic of an
argument.
o Example: =NOT(A1 > 5)
For Detail --->Click here
25. IFERROR - Returns a specified
value if a formula results in an error.
o Example: =IFERROR(A1/B1,
"Error")
For Detail --->Click here
26. IFNA - Returns a specified
value if #N/A error occurs.
o Example: =IFNA(VLOOKUP(A1,
B1:B10, 2, FALSE), "Not Found")
For Detail --->Click here
27. XOR - Returns TRUE if an odd
number of arguments are TRUE.
o Example: =XOR(A1 > 5,
B1 > 5)
For Detail --->Click here
28.SWITCH - Chooses a value from a list
of options.
o Example: =SWITCH(A1, 1,
"One", 2, "Two", "Other")
For Detail --->Click here
29.IFS - Tests multiple conditions and
returns the first true value.
o Example: =IFS(A1 =
"Red", "Stop", A1 = "Yellow", "Slow")
For Detail --->Click here
30.CHOOSE - Returns a value from a list
based on a position.
o Example: =CHOOSE(2,
"Apple", "Banana", "Cherry")
For Detail --->Click here
31. TRUE - Represents a TRUE
logical value.
o Example: =TRUE()
For Detail --->Click here
32.FALSE - Represents a FALSE logical
value.
o Example: =FALSE()
For Detail --->Click here
33.ISNUMBER - Checks if a value is a
number.
o Example: =ISNUMBER(A1)
For Detail --->Click here
34.ISEVEN - Checks if a number is even.
o Example: =ISEVEN(A1)
For Detail --->Click here
35.ISODD - Checks if a number is odd.
o Example: =ISODD(A1)
For Detail --->Click here
36.ISERROR - Checks if a value is an
error.
o Example: =ISERROR(A1)
For Detail --->Click here
37.ISERR - Checks for any error except
#N/A.
o Example: =ISERR(A1)
For Detail --->Click here
38.ISBLANK - Checks if a cell is empty.
o Example: =ISBLANK(A1)
For Detail --->Click here
39.ISLOGICAL - Checks if a value is
TRUE or FALSE.
o Example: =ISLOGICAL(A1)
For Detail --->Click here
40.ISFORMULA - Checks if a cell
contains a formula.
o Example: =ISFORMULA(A1)
For Detail --->Click here
