Basic Functions
Beginner
SIGN Function
Determine the sign of numbers using the SIGN function.
Task:
You are analyzing monthly profit/loss data and need to quickly categorize each month as either profitable, loss-making, or break-even. Determine if each profit/loss value is positive, negative, or zero by using the SIGN function in column C.
Learning Objectives:
- Learn the SIGN function
- Understand number classification
- Practice conditional analysis
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Month | Profit/Loss | Sign |
| 2 | Jan | 1500 | |
| 3 | Feb | -800 | |
| 4 | Mar | 0 | |
| 5 | Apr | 2200 | |
| 6 | May | -300 |
What this exercise teaches (contains the answer)
The SIGN function helps classify numbers based on their sign, useful for quick conditional analysis or formatting.