Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Interpolation Problem

Let's say I have 2 values: one at F1 and the other at F8.
By using linear interpolation I can solve for F2, F3, F4, F5, F6 and F7
(the two other values that are needed for the interpolation are not
relevant for my problem).

Problem:
The two values that I have are not always in F1 and F8.
They now can be at F2 and F7.

Question:
How can I apply the interpolation without knowing where exactly my two
values appear? I do know for sure that I have two values and that there
are cells in between those two values that are needed to take
interpolated values...

I hope I am clear.

Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interpolation? Mel Excel Worksheet Functions 1 June 1st 10 04:09 PM
interpolation atatari New Users to Excel 3 February 23rd 06 07:58 PM
interpolation atatari Excel Discussion (Misc queries) 0 February 13th 06 03:49 AM
Interpolation teen New Users to Excel 3 December 22nd 05 03:47 PM
help with interpolation and limit of interpolation uriel78 Excel Discussion (Misc queries) 0 February 17th 05 04:27 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"