 # TRUNCATE Function

The TRUNCATE function trims and returns (without rounding) the number value you specify at the number of decimal points you specify.

TRUNCATE is also used to evaluate whether a specific amount or if any decimal places exist at all (See example below). The difference between the TRUNCATE function and the ROUND function is that TRUNCATE simply "cuts off" a number at a specified digit, while ROUND actually rounds a number up or down, based on where you want the number rounded.

 Function name TRUNCATE Usage model TRUNCATE ( VAR, NUM ) Parameters This function requires you to replace two parameters: VAR The function shortens this number value by a certain amount of places after the decimal point. NUM The function shortens VAR by this specified value. Result A number value.

## Example

You can truncate a decimal number a specified number of places after a decimal point.

For example, the following script truncates the number 5.9375 to include only the first two digits after the decimal point. The truncated value is 5.93:

```SET NumberVar TO TRUNCATE ( 5.9375, 2 )
```

In the next example, however, a Computation tests if the value of Rent Amount includes cents. The variable is then formatted to eliminate the text AND NO CENTS from being merged when the variable contains only a whole number:

```IF Rent Amount = TRUNCATE( Rent Amount, 0 )
FORMAT( Rent Amount, "NINE DOLLARS" )
ELSE
FORMAT( Rent Amount, "NINE DOLLARS AND TWELVE CENTS" )
END IF
```