Need a book? Engineering books recommendations...

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

Re: Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
I'm not sure what your question is but I think you want to use the "F4" key.  You can learn about this by hitting "F1" (help) and typing in "relative reference".

HTH
MJ

--- On Wed, 7/22/09, Timothy Hilton <thilton(--nospam--at)lhcengineers.com> wrote:

> From: Timothy Hilton <thilton(--nospam--at)lhcengineers.com>
> Subject: Excel
> To: seaint(--nospam--at)seaint.org
> Date: Wednesday, July 22, 2009, 7:46 AM
> 
> 
> 
>  
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> 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
> 
> 
>    
> 
> 
> 
>  
> 
> 
> 

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********