I might be doing something wrong, but that formula doesn't seem to be
working.

this yr = 10
last yr = 0
increase = 10
% of increase over last year = WHAT? (how is WHAT stated as a %? 100% or is
100% only valid if last year had a value other than zero?
--
Jane P


"DNA" wrote:

Percent change is:

100 (x-y)/y

So, that's x-y/y*100

Percent total is:

100 (x/y)

So, that's x/y*100

HTH