%TNEG

<< Click to Display Table of Contents >>

Navigation:  Reference > Functions >

%TNEG

This function reverses the sign of table cells if their values fall within the inclusive range specified.

Form of use:

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

The two wconstants specify the lower and upper limits respectively of the range.

Used in conjunction with format PNN, this function can be used to put parentheses round figures in a tables.

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

Examples of TNEG function:

mt #t1=%tneg(100.0,200.0),

mt #t2(c3-5,r1-4)=%tneg($low,$high),