Inverse of a function in Excel

[bines53]

Hello everyone !

How do Excel inverse Xֶ^3
Eg 1.27^3= 2.048

Thank you !

 

[Somendra Misra]

Hi Bines,

Back after a long time.

I am unable to understand your question.

=X^n
in general is like multiplying X n times.

Regards,

 

[bobhc]

1.27^3= 2.048..!!!!!!!!!

 

[bines53]

Hi,I need to do cube root of number sqrt 3 (x) ,x=2.048 ,The result ,1.27.

Thank you !

 

[Somendra Misra]

You can use =POWER(2.048383,1/3) or in general

=Number^(1/Nth root) e.g
=8^(1/3) will give 2.

Regards,

 

[bines53]

Somendra ,

Thank you !

Fun to go back to this wonderful forum !

 

[Hui]

You can also solve this using Goal Seek

Setup 3 cells

Note the formula for Cell D3 =Power(B3, C3)

Now goto Goal Seek
Data, What If Analysis, Goal Seek
We want to Set Cell: D3
to a value: of 8.00000000
by Changing cell: B3


Ok



You need to be careful here as if you enter a value of 8 instead of 8.00000
Excel may find a slightly wrong result
Try it for yourself