Question description:
This user has given permission to use the problem statement for this
blog.
repeat equation with different values of x until y =0. y=(3x^4 -235x^2 -12.5x +10124).
Can this be done with a single formula rather than dragging out a column
Solved by I. J. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
06/12/2017 - 02:24
hi
Excelchat Expert
06/12/2017 - 02:24
Hello!
Excelchat Expert
06/12/2017 - 02:25
Welcome, Thanks for choosing Got It Pro-Excel!
Excelchat Expert
06/12/2017 - 02:25
How may I help you today!
User
06/12/2017 - 02:25
how do I make an equation equal zero with a single formula
Excelchat Expert
06/12/2017 - 02:26
OK I'll guide you
Excelchat Expert
06/12/2017 - 02:26
Do you know how to use solver in Excel?
User
06/12/2017 - 02:26
no
Excelchat Expert
06/12/2017 - 02:26
OK,Please follow me
User
06/12/2017 - 02:26
ok
Excelchat Expert
06/12/2017 - 02:27
Which Excel are you using,please? 2013?
User
06/12/2017 - 02:27
2016
Excelchat Expert
06/12/2017 - 02:27
OK
Excelchat Expert
06/12/2017 - 02:28
On the Data tab, in the Analysis group, click Solver
Excelchat Expert
06/12/2017 - 02:28
A dialouge box opened?
User
06/12/2017 - 02:28
where
Excelchat Expert
06/12/2017 - 02:29
Are you doing with me? Or only want to get procedure?
User
06/12/2017 - 02:29
procedure
Excelchat Expert
06/12/2017 - 02:29
OK
Excelchat Expert
06/12/2017 - 02:30
Can I give you a good link to this proceudre so that you can easily follow that even later if you want?
User
06/12/2017 - 02:30
ok
Excelchat Expert
06/12/2017 - 02:31
Because now problem is solved as I told you about solver so you are very near what you require :)
Excelchat Expert
06/12/2017 - 02:31
Let me give you
Excelchat Expert
06/12/2017 - 02:31
Please one thing important in start please, when you Got solution please END this session & rate me 5 if you are satisfied,Thanks
Excelchat Expert
06/12/2017 - 02:31
https://support.office.com/en-us/article/Define-and-solve-a-problem-by-using-Solver-5d1a388f-079d-43ac-a7eb-f63e45925040
Excelchat Expert
06/12/2017 - 02:31
This is an authentic link which will guide you properly.
Excelchat Expert
06/12/2017 - 02:32
Is there anything else you want to know regarding this issue?
User
06/12/2017 - 02:32
Will it work for formula 1a (B53)
Excelchat Expert
06/12/2017 - 02:33
Yes but you have to make formula in resemblance with method the link I given to you
Excelchat Expert
06/12/2017 - 02:33
Means you have to use that easy simbles
Excelchat Expert
06/12/2017 - 02:33
It will solve all the formuas
Excelchat Expert
06/12/2017 - 02:34
Of any type
User
06/12/2017 - 02:34
ok thanks
Excelchat Expert
06/12/2017 - 02:34
Please follow all instructions in that link'
Excelchat Expert
06/12/2017 - 02:34
please END this session & rate me 5 if you are satisfied,Thanks
User
06/12/2017 - 02:34
will do
Excelchat Expert
06/12/2017 - 02:34
Thanks for using Got It Pro-Excel!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.