Need a book? Engineering books recommendations...

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

Re: Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Timothy,
 
        I have not used EXCEL at the level you are discussing; but I have used both LOTUS 123 and PlanPerfect at that level.  Both of these spreadsheets allowed the user to have the option of creating "User Defined Functions".  Perhaps you can find something in the users guide under that topic that you could use.
 
        Good luck!
 
Regards,
 
H. Daryl Richardson
----- Original Message -----
Sent: Wednesday, July 22, 2009 8:46 AM
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. 

 

Thanks,

 

Timothy K. Hilton, E.I.

Engineering Intern

 

LHC STRUCTURAL ENGINEERS

P.O. Box 10567

1015 Wade Avenue

Raleigh, NC 27605-0567

 

919.832.5587 x 20

thilton(--nospam--at)lhcengineers.com