BISECTION FOR FINDING THE ROOT OF AN EQUATION ON EXCEL

[tattyana]

i am trying to use an excel spreadsheet or the bisection method in maths to
ind a root of an equation

I have my lower boundary and upper boundary and mid value
when the mid value produces a result that is less than or more than zero
depending which it is i may want the answer to go to another cell but cant
figure out how to do it

 

[John]

i am trying to use an excel spreadsheet or the bisection method in maths to
ind a root of an equation

I have my lower boundary and upper boundary and mid value
when the mid value produces a result that is less than or more than zero
depending which it is i may want the answer to go to another cell but cant
figure out how to do it

tattyana,
You have posted to the wrong newsgroup. This newsgroup is devoted to
question on MS Project, a planning/scheduling application. I suggest you
post to a more appropriate newsgroup, which based on your question, may
or may not be an Excel newsgroup.

John
Project MVP