Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc