Forum Discussion
Leah Argento
Jun 08, 2018Copper Contributor
Help With Formula Error
| 2017 | 2018 | % Diff | |
| January | |||
| Signature | $1,241 | $0 | -100% |
| Boosters | $0 | $894 | #DIV/0! |
| Total | $1,241 | $0 | -100% |
What should my formula for "Boosters" be to return the correct % Diff of 100% ?
1 Reply
- Detlef_LewinSilver Contributor
Leah,
let's hope your former math teacher will not read this.
100% of 0 is ... 0! Not 894.