Hi ,(adsbygoogle = window.adsbygoogle || []).push({});

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 abovethe input value.

For example , if myinput valueis 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

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Generate a function on excel

Loading...

Similar Threads - Generate function excel | Date |
---|---|

The downloader can't currently generate links | Saturday at 5:37 PM |

Positive-only sigmoid function | Oct 20, 2017 |

Dedicated random number generators | Jul 30, 2013 |

Random Generator in Excel 2013 | Jul 29, 2013 |

Next Generation Computer Hardware Coming Soon | Jul 3, 2012 |

**Physics Forums - The Fusion of Science and Community**