Generate a function on excel

  • Thread starter brad sue
  • Start date
  • #1
281
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
 

Answers and Replies

  • #2
4,465
72
I'm a bit autodidactic in Excel and I'd love to see too somebody to show how coordinates of cells could be generated by a numerical expression. As the problem is now, I figure you need a lot of (nested) copy pasted fuctions like IF(condition; output if true; output if false).

Success.
 
  • #3
4,465
72
Got the spreadsheet ready. Not a big deal. I used "AND" functions to determine in between-which value the input is. Then IF functions to get the series corresponding with it. And MAX functions to get that particular series into the output cells. So, how would you do it?
 
Last edited:
  • #4
281
0
Andre said:
Got the spreadsheet ready. Not a big deal. I used "AND" functions to determine in between-which value the input is. Then IF functions to get the series corresponding with it. And MAX functions to get that particular series into the output cells. So, how would you do it?
thanks I ll be back soon
 

Related Threads on Generate a function on excel

  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
1
Views
5K
  • Last Post
Replies
3
Views
3K
  • Last Post
Replies
3
Views
64K
Replies
1
Views
698
  • Last Post
Replies
2
Views
2K
Replies
2
Views
940
  • Last Post
Replies
5
Views
858
  • Last Post
Replies
2
Views
5K
  • Last Post
Replies
6
Views
2K
Top