algebra in excel help

[kamelkid2]

im putting together a business model and one of the functions im making is a calculator to determine sale price to equal a defined profit margin.

ive put together a formula to do this but i cant wrap my mind around how to put it into excel to give a nice simple solve for X

the equation im working on now is:

Please Login or Register  to view this content.

i can work this out on paper and it gives me an x value of 74.295. when i plug that into my calculator it returns me 0.40 (a 40% net profit margin), but the end user will be defining the profit margin so i need this to be dynamic.

can anybody help me plug this in to achieve this? im working on 2007 excel but programming for 97-03 compatibility

thank you guys so much

[kamelkid2]

solved it. i just did a step by step method in different cells and then combined all the references into one concise equation.

it is:

=(((I63+I62+I61+I59+I58+I57)*B1)-(I50+I51+I52+I53+I54+I55+I56+I57+I58+I59+I61+I62+I63))/(H19-(B1*H19))

not that it matters to anyone...

[royUK]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[6StringJazzer]

I have no idea how your solution relates to the question you asked.

If .40 is your profit margin and x is the price, you need to set .40 to M and solve for x in terms of M. Then the user can set M and the formula will provide the price.

=(M*b+a)/(d-d*M)

where M is the desired margin, a is the first constant (758.56), b is the second constant (1669.76), and d is the x multiplier (32).

See attached.