Finding x in y=x^3+x^2+x

[coelhothiago]

I've an equation of the 3º.
To enter with the x and find y, i know!
I want to enter with the y and find the x. How do I do this in excel? How do i do the same in VBA?

[royUK]

Please don't post duplicate threads in multiple forums.

[ravishankar]

Hi
if A1= x value
B1= =A1^3+a1^2 + A1
Goto Tools menu > goal seek > set cell = B1 > to value = enter the desired Y value > by changing cell = A1 > click OK
for VBA
enter y value in C1 and run the macro with the following codes

Sub Macro1()
Range("B1").GoalSeek Goal:=Range("C1"), ChangingCell:=Range("A1")
End Sub

Ravi