View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default How to obtain the root of f(x) in this interval?

In article ,
says...
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