A comparison asks a yes-or-no question. Excel answers TRUE (yes) or FALSE (no).
keyboard Typing formulas is easiest on a computer with a keyboard.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Score | Passed? | |
| 2 | Tariq | 71 | ||
| 3 | Nadia | 59 | ||
| 4 | Daniel | 50 | ||
| 5 | Quinn | 74 | ||
| 6 | Jamal | 42 | ||
| 7 | Isla | 43 | ||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 |
A yes-or-no question. Excel answers TRUE (yes) or FALSE (no).
> more than, < less than>= more than or equal to (at least), <= less than or equal to (at most)= equal to, <> not equal to=B2>=50 asks "is B2 at least 50?". Watch the edges: 50>50 is FALSE, but 50>=50 is TRUE.
Compare two Excel sheets cell by cell or row by row. Formulas to find missing rows and changed values, conditional formatting, and a no-formula option.
The basic Excel formulas every beginner needs, in the order to learn them: +, SUM, AVERAGE, COUNT, ROUND, percentages, IF and $. Each with an example and free practice.
Know someone fighting with a spreadsheet? Send them this page.