Week 5 · 45-60 min
Conditional Formulas (IF, COUNTIF)
Week Summary
A quick preview of the main ideas in this week before you begin the slides.
- Recap: The IF Function
- Nested IF Statements
- COUNTIF for Conditional Counting
- SUMIF for Conditional Totals
Glossary
Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.
- Recap: The IF Function
- Recap: The IF Function
- Nested IF Statements
- Nested IF Statements
- COUNTIF for Conditional Counting
- COUNTIF for Conditional Counting
Recap: The IF Function
Progress
1 / 8
Use logic-based formulas to categorize and analyze data.
Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.
IF checks a condition and returns one of two results, like =IF(score>=60,"Pass","Fail").
It is useful for automatic labeling and categorization.
It can be combined with other formulas.
It brings logical decision-making into the spreadsheet.
It is one of the most useful beginner formulas.
Remember
IF formulas help spreadsheets respond differently depending on the data.
Recap: The IF Function
Slide 1 of 8
Use arrows or dots to move through the lesson
Practice
- Write 2-3 sentences about what you learned this week.
Coming Next Week: Next: Charts and Graphs