?
Solved

Sum required to work out percentage number goes up or down

Posted on 2010-11-20
3
Medium Priority
?
450 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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

777 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