Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-240
4200A-901-01 Rev. C / February 2017
FINDLIN Formulator function
Find using linear interpolation searches down the column until it finds a value that is closest (but does not exceed)
the user-specified value
X
.
FINDLIN
searches a column (vector)
V
, beginning at
START
. Linear interpolation is
then used to determine its decimal location between the found value and the next value in the column (vector).
The returned index number (in decimal format) indicates the position of the specified value.
Usage
FINDD(
V
,
X
,
START
)
V
The name of any column (vector) listed under Columns
X
Any value, which may be the result of another calculation
START
The row number (index) of the starting value for the search
Example 1
Assume you want to use
FINDLIN
to locate value 6 in the following array:
(Index 1)0
(Index 2)1
(Index 3)4
(Index 4)8
The search finds the index marker that is closest to (but does not exceed) 6. In this case, Index 3 is the
closest. Linear interpolation is then used to determine the decimal position of the specified value (6) that is
between
Index 3
(value 4) and
Index 4
(value 8). Value 6 is halfway between Index 3 and Index 4.
Therefore,
FINDLIN
will return Index 3.5.
Example 2
IF = AT(ANODEI, FINDLIN(ANODEV, 0.7,
FIRSTPOS(ANODEV)))
Also see
(on page 6-239)
(on page 6-241)