TRUNC returns a truncated (cut off) value
Syntax
TRUNC(NumExp, NumVal)
Arguments
- NumExp is the value to be truncated;
- NumVal is the number of decimal places that is to be maintained (should be a value).
- Please note that truncating is NOT equal to rounding or defining decimal places in Slots & Properties. It really cuts off the number on a defined number of decimals;
- For rounding please use the ROUND() function;
Examples
TRUNC(A,3)
for A=2.274825638 returns
2.274
Quick links: Functions overview | Attribute overview | Constants overview | Dimensions overview