Sum required to work out percentage number goes up or down

in the attached spreadsheet are a series of number on row 1.  Row 2 shows how many percent the numbers have moved by each month which are all correct until you get to cell S2 where it says that 2094 is only 42.74% higher than 1199 which is not correct.

Can someone figure out the sum I need to correct this please?
Book1.xls
SimonreproAsked:
Who is Participating?
 
Alan HardistyConnect With a Mentor Co-OwnerCommented:
Try this for size!
 Book1.xls
0
 
Alan HardistyCo-OwnerCommented:
What I have done is take the increase / decrease and worked out what the percentage increase / decrease is over the previous months figure.
0
 
SimonreproAuthor Commented:
Perfect, thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.