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).

Remarks

  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

2.274

 

Quick links: Functions overview | Attribute overview | Constants overview | Dimensions overview

  • No labels