Difference between two values.

[Romano_odK]

Good morning,
I can't figure out what I am doing wrong here. I want to know the difference in % between the cost price and the purchase price taking into account the factor I have. Usually I add 3% to the purchase price and that is what I like to see but what I get is 2,75 instead of the 3% I added. What am I doing wrong here?

Thank you for you time.

Romano

Artikelen beheren XML 5.01.xlsm
	A	B	C
1	Purchase price	Cost price	Factor
2	74,40	2,55	30
3
4	2,75%
Sheet2

Cell Formulas
Range	Formula
A4	A4	=(100%-(((A2/C2)/B2)))

 

[RoryA]

How did you calculate the 74.4?

 

[Romano_odK]

How did you calculate the 74.4?

That is not a calculation, just the value of a product that I am buying.

 

[RoryA]

Then what does this mean:

Usually I add 3% to the purchase price

Where did you add that? To get the 30 (which I think should be 30.05 if so).

 

[Romano_odK]

Then what does this mean:


Where did you add that? To get the 30 (which I think should be 30.05 if so).

Usually I add 3% to the purchase price to get the cost price. Now I have the value of the Purchase price which 74.40 divided by the factor 30 makes 2.48. Now to get the costs price I add 3% to the purchase price of 2.48 which is 2.55. I want to check if there is indeed 3% difference between the cost price and purchase price with all my products, but I get a different number with my formula. So my question is, what am I doing wrong here.

 

[Alex Blakenburg]

You have 2 issues.
The initial calculation is 1.03 x $ 2.48 = $ 2.5544.
The base of the 3% is 2.48 in your calculation above you are using 2.55 as the which will give you a smaller %
ie instead of .03/1 you are doing .03/1.03

The 2nd issue is that 2.55 is a round down of 2.5544, which also reduces your check calculation.

 

[Romano_odK]

You have 2 issues.
The initial calculation is 1.03 x $ 2.48 = $ 2.5544.
The base of the 3% is 2.48 in your calculation above you are using 2.55 as the which will give you a smaller %
ie instead of .03/1 you are doing .03/1.03

The 2nd issue is that 2.55 is a round down of 2.5544, which also reduces your check calculation.

Thank you for your answer, I can use this to solve the issue.