TRUNC
Truncates a number to an integer.
Syntax
=TRUNC(Value)
Arguments
| Name | Type | Description | 
|---|---|---|
| Value | Number | Number value to truncate. | 
Return
| Type | Description | 
|---|---|
| Number | Number value to truncate. | 
Examples
| Formula | Result | Comment | 
|---|---|---|
 | 7 | 
Truncates a number to an integer.
Syntax
=TRUNC(Value)
Arguments
| Name | Type | Description | 
|---|---|---|
| Value | Number | Number value to truncate. | 
Return
| Type | Description | 
|---|---|
| Number | Number value to truncate. | 
Examples
| Formula | Result | Comment | 
|---|---|---|
 | 7 |