Need a book? Engineering books recommendations...

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

RE: Excel

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

Actually, just found this



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