# excel

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

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.

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

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

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

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

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