excel

Discussion in 'Programmer's Corner' started by braddy, Sep 17, 2005.

  1. braddy

    Thread Starter Well-Known Member

    Dec 29, 2004
    83
    0
    Hi ,
    I have to generate a function on excel that does the following

    the problem is about polynomial interpolation.

    I have for example a column of values:
    -100
    0
    100
    200
    300
    400

    First , I need to find the value in the table that is 2 point above the input value.
    For example , if my input value is 118 the first value is 0.

    Second, my real problem is how to select the next four values ( and use them else where).

    For the same example, if we enter 118, the corresponding colum must be:
    0
    100
    200
    300

    I dont know how to go from a cell to another cell using a formula.
    I hope that you can understand me.

    thank you for your help
     
  2. hgmjr

    Moderator

    Jan 28, 2005
    9,030
    214

    It is not clear to me what you meant by this part of your problem description.

    Can you try to clarify what you mean by this? Maybe if you give another example it will become clearer to me.

    hgmjr
     
  3. braddy

    Thread Starter Well-Known Member

    Dec 29, 2004
    83
    0
    Sorry for the response time but I got my problem fixed .

    However,please, I would like to know how to create a link to use a result in another sheet?

    for example,
    I am working on the sheet 1. I found a solution.
    But I want to use this solution in the sheet2 ( of the same book)
    What can I do? ( this needs to work with array and colunm)

    Thank you
     
  4. hgmjr

    Moderator

    Jan 28, 2005
    9,030
    214
    Hi braddy,

    What you are attempting to do is pretty straightforward.

    For example:

    Say you have a value in cell A1 on sheet 1 and you want that value to be reflected into cell b6 in sheet 2.

    You start in sheet 2 with cell b6 selected. Then you type in the "=" sign to start an equation. You then select sheet 1 and select cell a1. Just hit "enter" key at this point and excel will switch back to sheet 2. You will then see the value of what was in sheet 1 cell a1 in sheet 2 cell b6. Now if you change the value in a1 on sheet 1 excel will update cell b6 on sheet 2. You will notice that cell b6 contains the equation =sheet1!a1 . This is excel's notation to indicate that the cell a1 is from sheet 1 rather than the local a1 cell.

    If this is too confusing you can always go to the HELP menu and excel will walk you step by step through the process. I have found the HELP menu to be very user friendly and easy to understand.

    hgmjr
     
  5. braddy

    Thread Starter Well-Known Member

    Dec 29, 2004
    83
    0
    Thanks I will try it this afternoon!
     
  6. braddy

    Thread Starter Well-Known Member

    Dec 29, 2004
    83
    0
    Hey, Do you know how to graph a y=f(x) if you have a table values?( with Excel)
    I tried graph but it gives me a X as function of time

    Thanks
     
  7. braddy

    Thread Starter Well-Known Member

    Dec 29, 2004
    83
    0
    Never mind!!
     
Loading...