What is TRUNC in Excel
TRUNC Function TRUNC Function
- 2 minutes to read
Returns a number truncated to the specified number of digits.
TRUNC (** number **, ** numberofdigits **) TRUNC (** number **, ** numberofdigits ** )
|SurnameSurname||Required / OptionalRequired / Optional||Data typeData type||descriptionDescription|
|numbernumber||Required||NumericNumeric||The number to truncate.|
|numberofdigitsnumberofdigits||Required||NumericNumeric||The number of digits to which the number will be truncated should.The number of digits to which to truncate number.|
If numberofdigits is greater than 0, will numberon numberofdigits truncated to the right of the decimal point If numberofdigits is greater than 0, number is truncated to numberofdigits to the right of the decimal. If numberofdigits 0 is will number truncated to an integer If numberofdigits is 0, number is truncated to an integer numberofdigits is less than 0, will numberleft on numberofdigits truncated from the decimal separator If numberofdigits is less than 0, number is truncated to numberofdigits to the left of the decimal.
TRUNC (123,654.2) TRUNC (123,654.2)
Returns 123.65. Returns 123.65.
TRUNC (123,654.0) TRUNC (123,654.0)
Returns 123, returns 123.
TRUNC (123.654, -1) TRUNC (123.654, -1)
Returns 120, returns 120.
- AngelList is good for raising seed capital
- Should I join CDAC?
- Counts emotional infidelity as fraud
- What weapons did the Seminole Indians use
- What is an agency
- How does a triple beam balance work
- What are the legal dangers of crowdfunding
- My phone is ruining my headphones
- Google search is a program
- What will Madonna's legacy be
- What is a lilin demon
- What is the forecast for the 2016 visa bulletin
- What are the types of CCTV camera
- How does epic music work
- Why does the American military like Trump
- Can you learn EMT online
- Why do you love to move
- How often are new habitable islands formed
- Schwannoma can cause fatigue
- How does hummus taste
- How can targeted ads do harm?
- Is a laptop allowed in Amrita
- Why does palm oil affect health
- How do I create a dashboard