percentage change

I have weekly data. I would like to create a monthly indicator showing the % change from the last two weeks compared to the last two weeks for each month. The output should look as follows: A B 1 16M01 % (where this calculation is ((16W03+16W04)-(16W01+16W02)) /...

Hello, I have a (hopefully) somewhat simple question however I am struggling to know how to write the formula for this in Excel as I can only really do the basics. Essentially, I have an 'X' cell, and a 'Y' cell. In cell 'Z' I want it to calculate the percentage difference of X to Y. Both...

I watched the excel videos 610-611 and I was hoping to find a solution for % change, after the reading the comments I found that you had suggested posting questions here. I searched but didn't find a match. When calculating the "% Of" in the pivot table, I find that I'm not actually calculating...

Hello, I would like to ask someone to help me modify a file that calculates percentage so that when I move the values in certain cells it automatically adjusts them to always reflect less than 7%. basically cell G14 should always be less than 7%... Heres a link. http://1drv.ms/1Jsbuzx

Really sorry for posting this as I know there are loads of solutions on here already, however I've tried them and they don't quite work solve my problem. I'm working out percentage change from one year to the next using =(A1-B1)/B1. I don't want to see the inevitable #DIV0! and don't want to...

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...