| A | B | C | |
| 1 | 66.8 | ||
| 2 | if A1>80 |
 |
|
| 3 | >A10="Heavyweight" | ||
| 4 | else if A1>=68 |
|
|
| 5 | >A10="Middleweight" | ||
| 6 | else if A1>=58 |
|
|
| 7 | >A10="Lightweight" | ||
| 8 | else |
|
|
| 9 | >A10="Flyweight" | ||
| 10 |
执行后，A10中的单元格值如下:
| A | B | C | |
| 1 | 66.8 | ||
| 2 | if A1>80 |
|
|
| 3 | >A10="Heavyweight" | ||
| 4 | else if A1>=68 |
|
|
| 5 | >A10="Middleweight" | ||
| 6 | else if A1>=58 |
|
|
| 7 | >A10="Lightweight" | ||
| 8 | else |
|
|
| 9 | >A10="Flyweight" | ||
| 10 |
执行后，A10中的单元格值如下: