Solved

Sum required to work out percentage number goes up or down

Posted on 2010-11-20
Medium Priority
453 Views
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
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
• 2

LVL 76

Accepted Solution

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

LVL 76

Expert Comment

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

ID: 34180415
Perfect, thank you!
0

Featured Post

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…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll