Unit 4: Spreadsheet Skills
Lesson 3
Conditional Functions
Empowerment Technologies
Senior High School Applied - Academic
Can you think of other
activities in which
spreadsheets can be used,
aside from their intended
functions?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 2
In what ways
do you think
spreadsheets
help the
business field?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 3
● Understand the conditional
functions in spreadsheets.
Learning
● Differentiate the usage of AND, IF,
Objectives OR, NOT, COUNTIF, SUMIF, and
At the end of the
IFERROR function in spreadsheets.
lesson, you should be ● Apply independently these
able to do the
following: different functions in
spreadsheets.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 44
What are
conditional
functions?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 5
Conditional
functions allow users
to perform different
operations based on
logical conditions.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 6
What are the
different
conditional
functions in
spreadsheets?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 7
Conditional
Functions
● IF / NESTED IFs
● AND
● OR
● NOT
● COUNTIF / COUNTIFS
● SUMIF / SUMIFS
● IFERROR
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 88
What are the differences of those
conditional functions?
9
IF Function
This tests whether
the argument is true
or false depending
on another logical
operation used.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 10
10
AND Function
This returns
values when both
arguments are
true.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 11
OR Function
This returns true
if either value is
true or both
values are true
and vice versa.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 12
12
NOT Function
This returns a
value that is
opposite of the
argument
(one argument
only).
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 13
What can we do if there are too
many arguments? Is it possible to
use functions?
14
Did you know?
Conditional statements involving
too many arguments can be done
through the nested IF statement.
15
Nested IF Function
This allows the user
to test multiple
conditions inside
another condition.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 16
Tip
Be careful with parentheses.
● A close parenthesis “)” that is not equal to
an open parenthesis “(” will give you a
syntax (code) error.
17
COUNTIF
Function
CountIF counts the
cells that satisfy a
COUNTIFS
specific condition. Function
COUNTIFS counts
the cells that satisfy
multiple conditions.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 18
SUMIF Function
SUMIF function
adds the values of
selected cells that
SUMIFS
Function satisfy a specific
condition. SUMIFS
function adds the
values of cells that
satisfy multiple
conditions.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 19
19
CountIF counts the
cells that satisfy a
specific condition.
COUNTIFS counts
the cells that satisfy
multiple conditions.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 20
Wrap Up
The conditional function in a spreadsheet is a built-in
program that allows a user to make a logical test between
a set of data.
AND, IF, OR, NOT statements are used to make simple
logical comparisons.
COUNTIF, COUNTIFS, SUMIF, SUMIFS, and IFERROR are
used to make more complex operations.
You can use nested functions depending on what you
need for your data. 21
Bibliography
Arias, Francisco Javier Carrera. “Conditional Functions in Spreadsheets”. DataCamp.
July 9, 2019. https://www.datacamp.com/community/tutorials/conditional-
functions-in-spreadsheets (accessed March 25 2020).
Cheusheva, Svetlana. “Excel Nested IF statement: examples, best practice and
alternatives”. Ablebits. May 7 2019. https://www.ablebits.com/office-addins-
blog/2018/06/06/excel-nested-if-statement/ (accessed March 25 2020).
Cheusheva, Svetlana. “Logical functions in Excel: AND, OR, XOR, NOT”. Ablebits.
August 23 2018. https://www.ablebits.com/office-addins-
blog/2014/12/17/excel-and-or-xor-not-functions/ (accessed March 25 2020).
22
Bibliography
“Language in the Philippines”. Ethnic Groups of the Philippines.
http://www.ethnicgroupsphilippines.com/people/languages-in-the-philippines/
(accessed March 25 2020).
Trifuntov, Alexander. “Google Sheets IF function - usage and formula examples”.
Ablebits. January 15, 2020. https://www.ablebits.com/office-addins-
blog/2017/05/16/if-function-google-sheets/ (accessed March 25 2020).
23
