Recap: Decisions with IF
Part of the Fundamentals section of Coddy's Excel journey — lesson 38 of 42.
Challenge
MediumA project proposal was scored by three reviewers. A1 says Scores, and the three review scores sit in A2, A3 and A4.
The committee's rule: a proposal is approved when the average review score is at least 75.
- In
C1: the average of the three scores, usingAVERAGE - In
C2: an IF that showsapprovedwhen the average inC1is at least 75, andrejectedotherwise
Use the exact lowercase words. Different review scores will be tested, some approved, some rejected, one sitting right on the boundary.
Try it yourself
Sheet1
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Scores | ||||||
| 2 | 82 | ||||||
| 3 | 74 | ||||||
| 4 | 69 | ||||||
| 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 Grid4Cell References
Referencing Other CellsFormulas That UpdateChained FormulasRanges from A1 to A10Recap: Cell References7Decisions with IF
The IF FunctionWriting an IFComparison OperatorsNested IFsRecap: Decisions with IF