percentage change

[techstyle20]

Hi,

I want to find out how to calculate a seasonal adjustment but my formula is extreemly complicated and probably incorrect. I need to calculate a weekly % change but I also need to take into account that the overall figures have changed too.

I have this weeks overall figures in cell D7 and last weeks figures in cell H7. I have the following formula in cell J7 which I presume is correct and calculates the percentage change based on that weeks figures. (please correct me if this is wrong!)

=IF(D7>H7,((D7-H7)/D7),-((H7-D7)/H7))

These figures are then split down again. I then need to calculate the % change from the previous weeks figures but i need to take into account the overall % change above.

I have this weeks figures stored in D12 and last weeks figures stored in E12. I need to find the % change from this week to last while taking ionto account that the overall numbers have changed. I have the following formula in cell G12:

=(IF(AND(D12=0,E12<>0),(E12*-100%-J7),IF(AND(E12=0,D12<>0),(D12*100%-J7),IF(D12=0,"-",IF(D12>E12,(((D12-E12)/D12)-J7),((E12-D12)/E12-J7))))))

Is this correct or is there a simpler way to calculate this?

Thanks in advance,

T

 

[ca.moazzam]

Hi please email me your file at ca.moazzam@gmail.com to suggest a solution.

Moazzam