Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]

Excel will not output algebraic formulas, if that is what you’re asking – only values.  I don’t know of any plug-ins to make this possible either, but you might want to look around as it wouldn’t seem that far-fetched that someone would have made one.


There are a lot of open-source math programs that can do what you’re talking about though. 

Check out



are a couple that I’ve had decent experience with.  There are likely others that work on windows…

has a fairly complete list of linux related math softs – several of which should work on windows on windows as well.  But be careful of what you’re looking at, a lot of whats on this page are programming library’s are word-type editors…


anyways, hope this helps


From: Timothy Hilton [mailto:thilton(--nospam--at)]
Sent: Wednesday, July 22, 2009 10:46 AM
To: seaint(--nospam--at)
Subject: Excel


Does anybody know, in Excel, how to return the value of a cell containing a dependent variable based on a fixed value of one of its independent variables?


For example, x and y are independent variables, and in some cell I have a formula f(x,y).  However, in another cell I want to return the value for f(x,5) or f(10,y).


Surely there is an easy way to program this?  I’ve tried Excel help and google, but I don’t know what to search for. 




Timothy K. Hilton, E.I.

Engineering Intern



P.O. Box 10567

1015 Wade Avenue

Raleigh, NC 27605-0567


919.832.5587 x 20