Percentage Question

[Joneye]

Questions 1
1) I use Number 1 as my current formula for adding % to a figure, after years i've spotted my method is not exact, question is why is that?
2) Is it as simple as using Number 2 to work out adding a percentage to a number ? or are there other ways of doing this.

% Formula	Raw Product Cost	Margin % to be added	Sell Price	Formula Used
1	1.00	10%	1.11	=SUM(B2)/(1-C2)
2	1.00	10%	1.10	=B3+C3

As always advice and help is welcomed.

 

[etaf]

i have always used
=B2*(1+c2),

or COST * ( 1 + percent)

the others dont seem correct to me

Book2
	A	B	C	D	E
1
2	1	12	10%	1.11	13.3333
3	2	12	10%	1.1	12.1
4
5	3	12	10%	13.2	13.2
6		10& of 12 is 1.2	12 + 1.2
Sheet1

Cell Formulas
Range	Formula
E2	E2	=SUM(B2)/(1-C2)
E3	E3	=B3+C3
E5	E5	=B5*(1+C5)

 

[MARK858]

Another option is

Book1 (version 1) new.xlsb
	A	B	C	D	E
5	4	12	0.1		13.2
Sheet12

Cell Formulas
Range	Formula
E5	E5	=B5+(B5*C5)

Although I always use the third option etaf posted

 

[FormR]

Hi, the way you are already doing it is the correct way, although the SUM() function is superfluous.

Book1
	A	B	C	D	E	F	G
1	Formula	Raw Product Cost	Margin % to be added	Sell Price	Margin	% Margin	Is correct?
2	1	1	10%	1.111111111	0.111111111	10.00%	TRUE
3	2	1	10%	1.1	0.1	9.09%	FALSE
4	3	1	10%	1.1	0.1	9.09%	FALSE
5	4	1	10%	1.1	0.1	9.09%	FALSE
Sheet1

Cell Formulas
Range	Formula
D2	D2	=B2/(1-C2)
E2:E5	E2	=D2-B2
F2:F5	F2	=E2/D2
G2:G5	G2	=F2=C2
D3	D3	=B3+C3
D4	D4	=B4*(1+C4)
D5	D5	=B5+(B5*C5)

 

[MARK858]

Depends whether it is an answer to the question

adding % to a figure

to work out adding a percentage to a number

or creating a 10% margin as per column C title

Margin % to be added

 

[FormR]

Depends whether it is an answer to the question

Yes, indeed

 

[Joneye]

Massive help one and all, studying still and this really helps seeing the logic from all the supporters.

 

[felixstraube]

Adding to what has already been said... here is a page that compares margin vs markup
Product Pricing and Profit Margin Calculation for Sales Success: The Definitive Formula Guide

Gross margin percentage = (Selling price – total cost) * 100 / selling price

vs

Markup % = (Selling price – costs) * 100 / costs