6: Clarius Model 4200A-SCS Parameter Analyzer
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)
The name of any column (vector) listed under Columns
Any value, which may be the result of another calculation
The row number (index) of the starting value for the search
Example 1
Assume you want to use
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,
will return Index 3.5.
Example 2
IF = AT(ANODEI, FINDLIN(ANODEV, 0.7,
FIRSTPOS(ANODEV)))
Also see
FINDD (on page 6-239)
FINDU (on page 6-241)
To Next Page
Loading...
Need help?
General
