Mathematic problem solving using Excel
I may be asked this fall to teach mathematics to a high school class & I
thought it would be fun for the students to see how easily a program such as Excel could be used to duplicate much of what calculus does when approaching a problem such as finding maximum & minimum along a complex curve. Problem is Ive not discovered how to get Excel to enter a logic loop and jump out of said loop when the logic conditions have been met. Will someone offer a source of information on this subject, especially an example of how its done so that I may use this example in my lesson plan? Ive got many really fun calculus problems that Ive solved using several other languages, but since most of these students are using Excel already, why not use it to teach them the simple technique of programming using it. |
Mathematic problem solving using Excel
Have a look at the solver tool in the help menus, this is how excel tackles problems like this regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=571681 |
Mathematic problem solving using Excel
"Dav" wrote: Have a look at the solver tool in the help menus, this is how excel tackles problems like this regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=571681 |
All times are GMT +1. The time now is 11:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com