?
Solved

Sum required to work out percentage number goes up or down

Posted on 2010-11-20
3
Medium Priority
?
453 Views
Last Modified: 2012-05-10
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
Comment
Question by:Simonrepro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
Alan Hardisty earned 2000 total points
ID: 34180395
Try this for size!
 Book1.xls
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 34180402
What I have done is take the increase / decrease and worked out what the percentage increase / decrease is over the previous months figure.
0
 

Author Closing Comment

by:Simonrepro
ID: 34180415
Perfect, thank you!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question