K
Kindlysinful
Hello,
I have a question about percentage calculations.
I have data in a1, a2, a3..... And I want find the percentage difference
from A2 and A1. Or, the most current entry with the previous entry.
I am using, "=IF(A1=0,"",(a2/a1)*0.1) and that will get me the difference
in a percentage value but it will not give me the negative percentage value.
All values come up as a positive number.
The cells are formated for "percentage"
Example
A1 23.00
A2 24.00
A3 18.00
When I compare A2 to A1 I will get 10.43%
When I compare A3 to A2 I will get 7.50%. This number should come up as
-7.50%
I have a question about percentage calculations.
I have data in a1, a2, a3..... And I want find the percentage difference
from A2 and A1. Or, the most current entry with the previous entry.
I am using, "=IF(A1=0,"",(a2/a1)*0.1) and that will get me the difference
in a percentage value but it will not give me the negative percentage value.
All values come up as a positive number.
The cells are formated for "percentage"
Example
A1 23.00
A2 24.00
A3 18.00
When I compare A2 to A1 I will get 10.43%
When I compare A3 to A2 I will get 7.50%. This number should come up as
-7.50%