Excel TRUNC Function
Thanks,
TAMATAM
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!
|
TAMATAM
No comments:
Post a Comment
Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.