Scribd
Upload
5 views11 pages

Mastering IF and COUNTIF Functions

The document discusses the IF and COUNTIF functions in Excel. It explains the structure and components of each function, provides examples of how to use them, and assigns an activity for students to practice using the functions.

Uploaded by

mike.saunders
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
5 views11 pages

Mastering IF and COUNTIF Functions

The document discusses the IF and COUNTIF functions in Excel. It explains the structure and components of each function, provides examples of how to use them, and assigns an activity for students to practice using the functions.

Uploaded by

mike.saunders
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Computing

With: Mr Mike

[Link]
Functions IF and COUNTIF
Date: 30 October 2023

LO: Understand how to use different functions in a spreadsheet.

Success criteria: Students can use IF and COUNTIF functions in a spreadsheet.

[Link]
The IF Function
The IF function is like asking a question, it is used to make choices.

IF ( Question, Do this if True, Do this if False ). There are three elements that
need to be included inside the brakets and they are separated by commas.

[Link]
The Three Elements
1. A question: this is a logical test or logical expression to which the answer can
be either True or False.

2. What is to happen or be displayed if the outcome of the logical test, or


‘condition', Is True.

3. What is to happen or be displayed if the outcome of the logical test, or


'condition', is False.

[Link]
The logical test
The logical test in an if function uses Boolean operators:

[Link]
Example
Here is an example of an IF function that tells you If a student has passed or
failed a test with a pass mark of 60.

[Link]
The COUNT IF function

The COUNT IF function counts the number of cells in a selected range that meet
a specific criterion.

It has the following structure:

The range selects the cells to be checked and the criterion is the condition that
determines which cells will be counted.

[Link]
Example
Here is an example of a COUNT IF function that counts how many students got a
B-:

[Link]
Activity Test Marks

Go to todays class, open the Test Marks document.

You need to create a MS Excel spreadsheet, before you do any work save the file
to your documents folder.

Use the correct formulae to carry out the calculations

Follow the instructions in the document.

[Link]
Pop Quiz
1. What is the structure for the IF function?
»
2. What is the structure for the COUNTIF function?
»
3. What is a Range?
» B2:D4
4. How do you write an absolute cell reference?
» $D$5

[Link]
Thank you.

In our next session, we will look at the COUNT and


COUNTA functions

[Link]

You might also like