Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

TRUNC returns TRUNC returns a truncated (cut off) value

Syntax

TRUNC(NumExp, NumVal)

Arguments

...

  1. 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;
  2. For rounding please use the ROUND() function;

Examples

TRUNC(A,3)

for A=2.274825638 returns

...