0 of 46 lessons complete.
Module 1: Spreadsheet Basics · Lesson 6 of 46
Order of Operations
Use parentheses to control the order Excel calculates in.
Step 1 of 20%
Excel follows math order of operations: parentheses, exponents, multiply and divide, then add and subtract. In C2, find the average of A2 and B2 by adding them in parentheses, then dividing by 2.
Target: C2
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Reading 1 | Reading 2 | Average | |||
| 2 | 20 | 30 | ||||
| 3 | ||||||
| 4 | Temp (°F) | Temp (°C) | ||||
| 5 | 212 | |||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $