Solved

how to get the percent of two value

Posted on 2007-11-22
9
4,293 Views
Last Modified: 2012-08-14
Hello guys,

I used to know how to do this, but I don't remember anymore after a long time without using it.

I have two value:

A=100,35
B=127,78

I would like to know what is the percent between A and B. How is the formula to get the percent.

Thanks


0
Comment
Question by:hidrau
  • 4
  • 3
  • 2
9 Comments
 
LVL 53

Expert Comment

by:Infinity08
ID: 20333778
If you want to know how much A is compared to B, expressed as a percentage, then just do :

        (A / B) * 100

or for your example : A is 78,53 % of B
0
 
LVL 1

Author Comment

by:hidrau
ID: 20333811
A is the cost of my product and B is the price to sale

then this count is true? because if I do 78,53 on A I will have a value different from B

0
 
LVL 84

Expert Comment

by:ozo
ID: 20333818
WHat do you mean by "between"
A is A * 100 / B % of B
B is B * 100 / A % of A
A is (A-B)*100/B % less than B
B is (B-A)*100/A % more than A
0
 
LVL 53

Expert Comment

by:Infinity08
ID: 20333827
No A is 78,53 % of B, so the cost is 78,53 % of the price.

If you want the inverse, then you use this formula :

        (B / A) * 100

which gives that the price is 127,33 % of the cost.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:hidrau
ID: 20333842
I need to get the percent of profit between my cost and value of sale

If I have A = 100 and add 30%  I will have 130
If I have A = 100 and the value of sale in 130 I must have 30% as percent.

0
 
LVL 53

Expert Comment

by:Infinity08
ID: 20333852
Then use :

        ((B - A) / A) * 100

So, for your earlier example

        ((127,78 - 100,35) / 100,35) * 100 = 27,33 %
0
 
LVL 84

Accepted Solution

by:
ozo earned 500 total points
ID: 20333855
B is (B-A)*100/A % more than A
0
 
LVL 1

Author Closing Comment

by:hidrau
ID: 31410547
thanks
0
 
LVL 53

Expert Comment

by:Infinity08
ID: 20334184
So, what I posted didn't help you ?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
Complex Numbers are funny things.  Many people have a basic understanding of them, some a more advanced.  The confusion usually arises when that pesky i (or j for Electrical Engineers) appears and understanding the meaning of a square root of a nega…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now