Does it matter that in both cells D50 and C50 are results from (SUM) formulas
of the coloum? Im pulling from C50 which is a formula that is adding the
coloum of C to get the sum. ?

"Thank you, Heath" wrote:

The cell is formatted for percent.

I will try the formula you gave me...I just pasted the formula and made sure
all the cells were correct, but it still gives me %0.00...???

"Toppers" wrote:

Percentage change is difference between the two years divided by the base
year (2006):

=('2007'!D50-'2006'!C50)/'2006'!C50

with cell formatted as %


For your formula, how is the cell formatted?

HTH


"Thank you, Heath" wrote:

Hi,

On Sheet #1 I have a list of amounts that I have added together for week one
in 2006. On Sheet #2 I have a list of amounts for week 1 2007. I want to a
find the difference in percet from week 1 in 2006 to week 1 in 2007. When I
do the operation it keeps giving me an answer of zero. ??? Im confucsed it
seems like a simple operation.


This is the formula that is giving me the answer of zero: (2006 is the name
of sheet #1, this formula is on sheet #2 called 2007)

='2006'!C50/'2007'!D50

thank you
Heath Taubitz
Lockheed Martin