Table of Contents
This tip is about the how to Use TRUNC Function on MS Excel. So read this free guide, How to Use TRUNC Function on MS Excel step by step. If you have query related to same article you may contact us.
How to Use TRUNC Function on MS Excel – Guide
Microsoft Excel is a spreadsheet program for Windows, macOS, Android and iOS that was created by Microsoft. It includes calculation tools, charts, pivot tables, and Visual Basic for Applications, a macro programming language. Excel is a program that is included in the Microsoft Office suite of programs. The TRUNC function in Microsoft Excel provides a number that has been truncated to a certain number of digits.
TRUNC is an Excel built-in function that is classified as a math/trig function. Can be used in Excel as a worksheet function (WS). The TRUNC function is a worksheet function that can be used in a formula in a worksheet cell.
Using the TRUNC function
Syntax
The syntax for the TRUNC function in Microsoft Excel is:
TRUNC( number, [digits] )
Parameters or Arguments
- The number to be truncated.
- Optional. Is the number of decimal places to display in the resulting truncated number. If this parameter is omitted, the TRUNC function will assume 0.
number
digits
returns
The TRUNC function returns a numeric value.
applies to
Final note
I hope you like the guide How to Use TRUNC Function on MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.