TRUNC returns a truncated (cut off) value
Syntax
TRUNC(NumExp, NumVal)
Arguments
...
- 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
...