K’the king

LOGICAL FUNCTIONS

1.AND
Syntax: = AND (logical 1, logical 2 ...)

Returns TRUE if all its arguments are TRUE; returns FALSE if one or
more argument is FALSE.

Logical1, logical2 ...   are 1 to 30 conditions you want to test that can be
either TRUE or FALSE.

Logic 1 Logic 2 RESULT

TRUE TRUE TRUE

FALSE FALSE FALSE
TRUE FALSE FALSE
FALSE FALSE FALSE

EX: =AND(35>23,21>19)  TRUE

2. OR
Syntax: = OR (logical1, logical2...)

Returns TRUE if any argument is TRUE; returns FALSE if all arguments

are FALSE.

Logical1, logical2...   are 1 to 30 conditions you want to test that can be

either TRUE or FALSE.

Logic 1 Logic 2 RESULT

TRUE TRUE TRUE

FALSE FALSE TRUE
TRUE FALSE TRUE
FALSE FALSE FALSE

EX: = OR (3>2, 4>5)  TRUE

1
 K’the king
3.IF
Syntax: = IF (logical_test, value_if_true, value_if_false)

Returns one value if a condition you specify evaluates to TRUE and

another value if it evaluates to FALSE. Use IF to conduct conditional tests on
values and formulas.

A2 A3 A4

Blue dry nice day

Cloudy dry bring umbrella

EX : =IF(AND(A2="blue",B2="dry"),C2,C3)  nice day

4.NOT
Syntax : = NOT ( logical )

Reverses the value of its argument. Use NOT when you want to
make sure a value is not equal to one particular value.

Logical   is a value or expression that can be evaluated to TRUE or

FALSE.

EX : =NOT ( 3>4 )  TRUE

COUNTING FUNCTIONS
2
 K’the king

A B C D E
1 EXAM CLEARED MARK
ROLL NO NAME DATE OR NOT ? S
1/12/20
2 1 C 09 # 20
2/12/20
3 2 C++ 09 23
3/12/20
4 3 JAVA 09 # 53
4/12/20
5 4 VB 09 48
5/12/20
6 5 VB .NET 09 # 72
7 6
8 COUNT 0 5 0 5
9 COUNTA 5 5 3 5
COUNTBLA
10 NK 1 1 3 1
11 COUNTIF 3

1.COUNT
Syntax: = COUNT (value1, value2...)

Counts the number of cells that contain numbers and also numbers within the
list of arguments. Use COUNT to get the number of entries in a number field that's in
a range or array of numbers.

Value1, value2 ...   are 1 to 30 arguments that can contain or refer to a variety
of different types of data, but only numbers are counted.

EX: = COUNT (A2:A6)  Refers table

2.COUNTA
Syntax: = COUNTA (value1, value2...)

Counts the number of cells that are not empty and the values within the list of
arguments. Use COUNTA to count the number of cells that contain data in a range
or array.

Value1, value2 ...   are 1 to 30 arguments representing the values you want to
count. In this case, a value is any type of information, including empty text ("") but
not including empty cells. If an argument is an array or reference, empty cells within

3
 K’the king
the array or reference are ignored. If you do not need to count logical values, text, or
error values, use the COUNT function.

EX : = COUNTA ( A2:A6)  Refers table

3.COUNTBLANK
Syntax: = COUNTBLANK (range)

Counts empty cells in a specified range of cells.

Range   : is the range from which you want to count the blank
cells.

Cells with formulas that return "" (empty text) are also counted.
Cells with zero values are not counted.

EX: = COUNTBLANK (A2: A6)  Refers table

4.COUNTIF
Syntax : = COUNTIF ( range, criteria )

Counts the number of cells within a range that meet the given
criteria.

Range   is the range of cells from which you want to count cells.

Criteria   is the criteria in the form of a number, expression, or text

that defines which cells will be counted. For example, criteria can be
expressed as 32, "32", ">32", "apples".

EX: = COUNTIF (E2:E6, “>35”)  Refers table