Is it a case of subtracting the later value from the former 26% - 28% = -2%

So if the first value is in A1 and the second in B1 then in C1 enter =B1-A1

However this may not be what you want? The difference is actually 2
percentage points, not necessarily 2%. To compute the true percentage
variance you must know the underlying data from which the individual
variances are derived; unless the denominator for the original percentages
are the same, in that case the points movement is equal to the true
percentage.

--

Regards,
Nigel




"azteca" wrote in message
...
hi, first time user
I am working in a project and i need to find out the formula for the
following example:
first month 28% positive results second month 26% positive results 3rd
month
29%
so comparing month to months there was a -2% between 1st and 2nd month and
an +3% increase from 2nd month to 3rd month.
how can I display the results in a cell so it will show -% or +% depending
on the percentage per month?
--
azteca