How to show negative percentage?
Harlan Grove is pretty smart.
Biff
"brett" wrote in message
ups.com...
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
|