In Excel, if I know cost and the margin I want, what formula do I use to calculate sell price?
G Guest Nov 4, 2004 #1 In Excel, if I know cost and the margin I want, what formula do I use to calculate sell price?
M Max Nov 4, 2004 #2 One way Assume you have in A1:C2 CostPrice Margin SellPrice $2.00____10%_____?? Put in C2: =A2*(1+B2) C2 (formatted as currency) will return: $2.20 (the selling price based on a 10% margin) Copy C2 down to compute likewise for other rows
One way Assume you have in A1:C2 CostPrice Margin SellPrice $2.00____10%_____?? Put in C2: =A2*(1+B2) C2 (formatted as currency) will return: $2.20 (the selling price based on a 10% margin) Copy C2 down to compute likewise for other rows
G Guest Nov 4, 2004 #3 Thanks Max, I really appreciate it. Mark Max said: One way Assume you have in A1:C2 CostPrice Margin SellPrice $2.00____10%_____?? Put in C2: =A2*(1+B2) C2 (formatted as currency) will return: $2.20 (the selling price based on a 10% margin) Copy C2 down to compute likewise for other rows Click to expand...
Thanks Max, I really appreciate it. Mark Max said: One way Assume you have in A1:C2 CostPrice Margin SellPrice $2.00____10%_____?? Put in C2: =A2*(1+B2) C2 (formatted as currency) will return: $2.20 (the selling price based on a 10% margin) Copy C2 down to compute likewise for other rows Click to expand...