Sunday, 22 July 2012

Excel TRUNC Function Syntax and Example

Excel TRUNC Function
TRUNC is numerical function which truncates a number to an integer by removing the specified no.of digits in decimal, fraction portion.

Syntax:
=TRUNC (Value, No.of Digits)

Here:
VALUE which should be a number that you can truncate.
No. Of Digits refers to the size to truncate, if you don’t mention or specifies as zero this ,then the function will truncate entire decimal portion.

Examples:

NUMBER
No.of Digits
TRUNC  Function
Result
1123.6789

 =TRUNC(A3)
1123
1123.6789
1
 =TRUNC(A3,B3)
1123.6
1123.6789
3
 =TRUNC(A4,B4)
1123.678
1123.6789
2
 =TRUNC(A5,B5)
1123.67
1123.6789
0
 =TRUNC(A6,B6)
1123
TamaTam

 =TRUNC(A3)
#VALUE!


Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts