How to obtain the root of f(x) in this interval?

[Gaenn]

I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x) in
this interval. What is the value of x if i wish to obtain f(x)=0?

 

[Tushar Mehta]

I am trying to draw a graph here, plotted graph x, with function f(x) at
y-axis, does anyone know how to get the approximation to the root of f(x) in
this interval. What is the value of x if i wish to obtain f(x)=0?

If you know the function, use Solver. If you don't, eyeball the graph.
What I do is zoom in on the segment of interest by changing the axes
Xmin, Xmax, Ymin, and Ymax values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Bernard Liengme]

Lots of examples in book ISBN 0 7506 5613 1