How to show negative percentage?
On 8 Jan 2006 18:19:12 -0800, "brett" wrote:
If I divide two negative numeric cells and put the result into a
percentage cell, it will positive, even if the change is negative. For
example:
A B
1 -6249 -5810
A1/B1 = 107.56%
The change is moving from B to A. That means I should have a negative
change. How can I show that?
Thanks,
Brett
You could always multiply your answer by -1. However, a "negative" percentage
is not generally a meaningful concept.
What real world problem are you trying to solve?
--ron
|