Solved

# how to get the percent of two value

Posted on 2007-11-22
4,316 Views
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
Question by:hidrau
[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
• 4
• 3
• 2

LVL 53

Expert Comment

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

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

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

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

LVL 1

Author Comment

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

ID: 20333852
Then use :

((B - A) / A) * 100

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

LVL 84

Accepted Solution

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

LVL 1

Author Closing Comment

ID: 31410547
thanks
0

LVL 53

Expert Comment

ID: 20334184
0

## Featured Post

Question has a verified solution.

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

A Guide to the PMT, FV, IPMT and PPMT Functions In MS Excel we have the PMT, FV, IPMT and PPMT functions, which do a fantastic job for interest rate calculations.  But what if you don't have Excel ? This article is for programmers looking to re…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
###### Suggested Courses
Course of the Month3 days, 5 hours left to enroll