<< Click to Display Table of Contents >> Navigation:  Reference > Functions > %TVAL

This function assigns a new value to one or more table cells if their values fall within the inclusive range specified.

Form of use:

MT table [(part-id)] =%TVAL (wconstant,wconstant,wconstant),

The first two wconstants specify the lower and upper limits respectively of the range, and the third is the replacement value. Note that 'U' (undefined) may be used for any argument, but if it is used for either the first or the second then it must be used for both.

The values are replaced in situ, you cannot specify a new table for the changed figures.

Examples of TVAL function:

mt #t1=%tval(100.0,999.0,100.0),

mt #t2(r1)=%tval($low,$high,$new),