NotBurtReynolds
New Member
How would you calculate percentages of a set of numbers when one (or more) of the values is negative?
Calculating Contribution% with Negative Numbers
- Thread starter NotBurtReynolds
- Start date
Chihiro
Excel Ninja
That depends on your definition of contribution, and how it's being used.
Contribution can certainly be positive or negative.
Though, you didn't explain how each numbers contribute to total. So hard to give you answer.
SUM of all value = 4.9 not 4.8. I'm assuming it's not sum of these numbers.
Contribution can certainly be positive or negative.
Though, you didn't explain how each numbers contribute to total. So hard to give you answer.
SUM of all value = 4.9 not 4.8. I'm assuming it's not sum of these numbers.