TRUNC Function (Functions in Excel)
Number | Precision For Truncation | Truncated Number | |
1.47589 | 0 | 1 | =TRUNC(C4,D4) |
1.47589 | 1 | 1.4 | =TRUNC(C5,D5) |
1.47589 | 2 | 1.47 | =TRUNC(C6,D6) |
-1.47589 | 1 | -1.4 | =TRUNC(C7,D7) |
-1.47589 | 2 | -1.47 | =TRUNC(C8,D8) |
13643.48 | -1 | 13640 | =TRUNC(C9,D9) |
13643.48 | -2 | 13600 | =TRUNC(C10,D10) |
13643.48 | -3 | 13000 | =TRUNC(C11,D11) |
What Does It Do ? |
This function removes the decimal part of a number, it does not actually round the number. |
Syntax |
=TRUNC(NumberToTuncate,Precision) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment