# excel

Thread Starter

#### braddy

Joined Dec 29, 2004
83
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

#### hgmjr

Joined Jan 28, 2005
9,029
Originally posted by braddy@Sep 17 2005, 01:34 PM
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
[post=10406]Quoted post[/post]​

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.
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

Thread Starter

#### braddy

Joined Dec 29, 2004
83
Originally posted by hgmjr@Sep 17 2005, 01:26 PM
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
[post=10407]Quoted post[/post]​
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

#### hgmjr

Joined Jan 28, 2005
9,029
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)
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

Thread Starter

#### braddy

Joined Dec 29, 2004
83
Originally posted by hgmjr@Sep 20 2005, 05:46 AM
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
[post=10471]Quoted post[/post]​
Thanks I will try it this afternoon!

Thread Starter

#### braddy

Joined Dec 29, 2004
83
Originally posted by braddy@Sep 20 2005, 07:43 AM
Thanks I will try it this afternoon!
[post=10473]Quoted post[/post]​
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

Thread Starter

#### braddy

Joined Dec 29, 2004
83
Originally posted by braddy@Sep 21 2005, 09:26 PM
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
[post=10517]Quoted post[/post]​
Never mind!!

Similar threads