There are two options available in excel for the same.
1. You can use goal seek. Follow following procedure for using goal seek.

As shown in picture above you want x value for f(x) being 0.
a. Go to Data -> What if analysis -> Goal seek

b. In set cell provide cell reference of F(x) (you want F(x) to be 0, right?)
c. In to value type 0.
d. In by changing cell provide cell reference of cell of x (you want value of x for which f(x) becomes 0.)
e. Press ok and see the result.
f. As we know it should give us two options for which f(x) becomes 0. But, goal seek provides least value for which f(x) becomes 0.
2. You can use solver option for the solution.
a. Go to data -> Solver (if you can’t find solver in data menu, go to options->add ins->Excel add ins -> solver add in and add the add in of solver.)

b. In set object give reference of F(x)
c. To value of 0
d. In by changing cell give reference of x.
e. Click solve and you get the result.
Comments