Reverse Engineering

[Boofhead]

Hi,

Can someone help me find x in the following equation please?

34617.37 = (POWER(5000/x,.68))*18565

Thanks

 

[mrMozambique]

How about 2000.001?

I used the Goal Seek Function.

Cell A1 = 34617.37
Cell B1 = =(POWER(5000/C1,0.68))*18565
Cell C1 = started with 1, but used goal seek to change this number to 2000 to make your formula work.

here's a link: http://www.addictivetips.com/microsoft-office/goal-seek-in-excel-2010/

 

[Andrew Poulsom]

Simplify your equation in steps like this:

<TABLE style="WIDTH: 186pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=248 border=0 x:str><COLGROUP><COL style="WIDTH: 186pt; mso-width-source: userset; mso-width-alt: 9069" width=248><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 186pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=248 height=17>34617.37=(POWER(5000/x,0.68))*18565</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>34617.37=((5000^0.68)/(x^0.68))*18565</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>1=((5000^0.68)/(x^0.68))*18565/34617.37</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>x^0.68=(5000^0.68)*18565/34617.37</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>x=((5000^0.68)*18565/34617.37)^(1/0.68)</TD></TR></TBODY></TABLE>

The formula:

=((5000^0.68)*18565/34617.37)^(1/0.68)

returns 2000.001.

 

[Boofhead]

Both excellent solutions!! Thank you very much.