Thinkabara

📗 Excel for Beginners · Lesson 7 of 10

IF: if... then...

Google Classroom

The IF function in Excel with a passing grade example, and COUNTIF for counting by a condition.

The tasks in this lesson

1. Pass or fail

  1. C2: =IF(B2>=55,"Pass","Fail")
  2. Drag C2 down to C7

💡 IF(condition, value if true, value if false). Text always goes inside quotation marks.

2. How many passed?

  1. B9: =COUNTIF(C2:C7,"Pass")

💡 Even =COUNTIF(B2:B7,">=55") gives 4, straight from the scores.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet