IF: label an order as Big or Small
Lesson 3 of 5In cell C2, write a formula that shows "Big" if the Amount in B2 is greater than 1000, and "Small" otherwise.
| A | B | C | |
|---|---|---|---|
| 1 | Order | Amount | Size |
| 2 | #1041 | 1,450 | |
| 3 | #1042 | 380 | |
| 4 | #1043 | 999 |
Type in the formula bar above and press Enter to check.