Finding a root by bisection method in Excel
Working on a maths assignment and we're trying to use Excel for a bisection method. $$\frac12 e^+\frac-\frac32=0$$ Here is a pic, I can't get the formula to work with the exponent. This is what we've done so far, can anyone spot what we've got wrong with the formula?
user147263
asked Apr 18, 2015 at 12:55
Maths Thief Maths Thief
25 1 1 silver badge 4 4 bronze badges
$\begingroup$ See math notation guide for formatting formulas. $\endgroup$
– user147263
Commented Apr 18, 2015 at 19:10
1 Answer 1
$\begingroup$
It should read (1/(2*A8)) For the second term
Your current second term reads (1/2 *A8) which means $\frac < 2>A8$
answered Apr 18, 2015 at 13:09
550 4 4 silver badges 12 12 bronze badges
$\begingroup$ Thanks for that, got it sorted now! $\endgroup$
Commented Apr 18, 2015 at 13:31
You must log in to answer this question.
- numerical-methods
- roots
- math-software
Related
Hot Network Questions
Subscribe to RSS
Question feed
To subscribe to this RSS feed, copy and paste this URL into your RSS reader.
Site design / logo © 2024 Stack Exchange Inc; user contributions licensed under CC BY-SA . rev 2024.9.10.15036
