Menu
Coddy logo textTech
START LEARNING
flag En iconEnglishdown icon

Pass or Fail with IF

Part of the Fundamentals section of Coddy's Excel journey — lesson 41 of 42.

challenge icon

Challenge

Easy

Add a verdict column to your grade book:

  1. Header: Result in G1
  2. In G2, G3 and G4: an IF that shows pass when that student's average (column F, same row) is at least 60, and fail otherwise

Use the exact lowercase words pass and fail. The tests will drop some students below 60, each verdict must follow its own row's average.

Try it yourself

Sheet1
ABCDEFG
1StudentTest 1Test 2Test 3TotalAverage
2Maya788592=SUM(B2:D2)=AVERAGE(B2:D2)
3Liam625872=SUM(B3:D3)=AVERAGE(B3:D3)
4Ava958893=SUM(B4:D4)=AVERAGE(B4:D4)
5
6
7
8
9
10
11
12
13
14

All lessons in Fundamentals

1Meet the Spreadsheet

What Is a Spreadsheet?Cells and ReferencesYour First CellsRows, Columns and the GridRecap: Meet the Grid

4Cell References

Referencing Other CellsFormulas That UpdateChained FormulasRanges from A1 to A10Recap: Cell References

7Decisions with IF

The IF FunctionWriting an IFComparison OperatorsNested IFsRecap: Decisions with IF

2Entering Data

Text and NumbersBuilding a Small TableEditing and Clearing CellsNumbers That Mean SomethingRecap: Entering Data

5Basic Functions

What Is a FunctionThe SUM FunctionThe AVERAGE FunctionMIN and MAXCOUNT and COUNTACombining FunctionsRecap: Basic Functions

8Project: Grade Book

Grade Book SetupTotals and AveragesPass or Fail with IFFinishing the Grade Book

3Your First Formula

What Is a Formula?Writing a FormulaFormulas with CellsArithmetic OperatorsOrder of OperationsRecap: First Formulas

6Working with Text

Joining TextUPPER and LOWERMeasuring Text with LENLEFT, RIGHT and MIDRecap: Working with Text