Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Beta Setup Problem | Setting up and Configuration of Excel | |||
Excel 2003 code, problem in Excel 97 | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Formatting cells, Need help solving a problem with excel | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) |