• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

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
0
Simonrepro
Asked:
Simonrepro
  • 2
1 Solution
 
Alan HardistyCommented:
Try this for size!
 Book1.xls
0
 
Alan HardistyCommented:
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now