[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 766

# Strange one - Algebra!

Hi, on a spreadsheet i want to work out the missing variable

I know the desired Gross Profit = .65
I know the Cost of Sale = 1.306

How can i derive the sales price using a formula on excel?

Thanks
Seamus
0
Seamus2626
1 Solution

Commented:
Is the GP a percentage or an actual amount

SP = CoS + Profit

or

SP = CoS * (1 + ProfitPercentage)
0

Commented:
On another note, if this is something you will do regularly and in different scenarios, look into "Goal Seek".

``````http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html
``````
``````http://office.microsoft.com/en-us/excel-help/about-goal-seek-HP005203894.aspx
``````
0

Commented:
If gross profit is just 65 cents, then add them.
If it is a percentage, then do you mean you want 65% of the sale price to be profit?

GPP = Gross Profit Percent
SP = Sale Price
CS = Cost of sale

So CS/SP = 1 - GPP

or SP = CS/(1 - GPP)

julianH, in your formula, CoS is 65% greater than SP but the actual percent profit would only be 65/165 or about 39%
0

Commented:
And I don't think you need Goal Seek for this. Just plug that formula into the spreadsheet.
0

Author Commented:
This is what i was looking for.

Thanks for everyones input

Seamus
0

Commented:
@TommySzalapski I was going on the assumption he wanted to make a gross profit of 65%
0

Commented: