Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Any example to do caculus with excel
Thanks a lot. -- slamm ------------------------------------------------------------------------ slamm's Profile: http://www.excelforum.com/member.php...o&userid=15018 View this thread: http://www.excelforum.com/showthread...hreadid=390412 |
#2
|
|||
|
|||
Here are a few tips: http://www.tushar-mehta.com/ Search Googles: Calculus Excel http://www.mang.canterbury.ac.nz/peo...scom/links.htm Hope it can be of use Ola Sandström Enclosed: http://www.excelforum.com/attachment...tid=3641&stc=1 + From Excel Expert E-Letters: http://www.j-walk.com/ss/excel/eee/index.htm POWER FORMULA TECHNIQUE By Alab Beban Here is an example of how to solve a set of simultaneous equations using Excel. Start with equations that are linearly independent so that there is, in fact, a solution; e.g., 17 = 5x + 3y + 2z 13 = 2x + 4y + z 22 = 3x + 2y + 5z Put the coefficients of the unknowns in, e.g., A1:C3 (i.e., 5,3,2 in A1:C1, 2,4,1 in A2:C2, etc.); Put the constants (17, 13, 22) in, e.g., D1:D3; Highlight, e.g., E1:E3 and array enter (i.e., enter with Ctrl+Shift+Enter instead of just Enter) =MMULT(MINVERSE(A1:C3,D1:D3) and the solution vector (1,2,3) will appear in E1:E3; i.e., x=1, y=2, z=3 For a set of equations that does not have a solution, the #VALUE error will appear in E1:E3. +-------------------------------------------------------------------+ |Filename: PlotFcn.zip | |Download: http://www.excelforum.com/attachment.php?postid=3641 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390412 |
#3
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |