Calculate percentage change from a positive base
Your goal: Compare old and new values, distinguish growth from decline, and handle zero or negative starting values explicitly.
Full task requirements
Fill D2:D6 with (current − previous) / previous when the previous value is positive. Return Review base otherwise.
Weekly sign-upsChoose usable baselines
- Previous value
- Greater than zero
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 |
Step 1 of 3
Choose usable baselines
How the Excel rule works
The previous value is the denominator. This task sends zero and negative baselines to Review base. Select every usable comparison and inspect its calculation.
Inspect selected records and calculations
No records selected yet.
Selected count