Table( Can it find the next value as well as the previous?

[Robert Ameeti]

Forgive me if this question is simpler than I think it is but I've 
been wrapping my head around third order polynomial spline equations 
for curve definitions all day and my brain is a bit tweaked at the 
moment.

(I think there is an error in the docs for Table( but I'll get to 
that at the end of this post.)

Using the example from the docs:

keyField	dataField
0	2.50
50	2.35
100	2.25

I have a need that involves Table( and I'm thinking that I might be 
missing an option that I am not seeing.

My need is a mix of interpolation and table( where if my lookup value 
for the keyField was 95, that I would end up with a value of 2.26. 
(Given that 95 interpolated as being 90% between 50 & 100, so is 2.26 
90% towards 2.25 from 2.35)

If I use 95 as my keyField with the table( function, that will 
naturally give me 2.35 and if I use the keyField as my dataField, I 
can also retrieve the 50, but is there a natural way to go to the 
next value instead of the previous value that the table( function 
typically goes to?

(I'll then figure the proportional amount to add to my first 
dataField value to get the interpolated dataField value.)

===

2nd wondering:

The Panorama Reference says in multiple places that Table( finds the 
closest match but the examples show that it returns the match based 
on the keyField not exceeding the keyData which to me is not the 
closest but rather the highest value that is not equal to nor higher 
than the next table value. Am I reading the docs wrong? This function 
has been around a very long time and I can't imagine that it would 
still be wrong.


-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

After a certain point money is meaningless. It ceases to be the goal. The game is what counts.
<><><><><><><><><><><><><><><><><><>