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
Solved

excel formula

Posted on 2013-12-05
3
242 Views
Last Modified: 2013-12-19
hello experts
i am simply trying to calculate the percentage difference between two columns and check against the third column to see how much is the difference

A1     B1    C1      D1                                                     E1

282   134    33   (B1-A1/A1)*100  =  -52.48%  

From the above, I have figured out the formula to find the percentage difference between b1 and a1, now I need to check if I am -52% down on the number comparing it with C1

I mean, what will the value in E1 if I take away 52.48% from C1

I hope you understand what I am trying to say?

Thanks
0
Comment
Question by:meyda
3 Comments
 
LVL 9

Assisted Solution

by:BlueYonder
BlueYonder earned 167 total points
ID: 39698080
In E1 use the formula =(1-D1/100)*A1
0
 
LVL 50

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 167 total points
ID: 39698091
Hi,

in E1 pls try

=C1*(100+D1)/100

Regards
0
 
LVL 4

Accepted Solution

by:
andrew_man earned 166 total points
ID: 39698127
D1
= (B1-A1)/A1
E1
=C1*(1+D1)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

789 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