# What is TRUNC in Excel

## TRUNC Function TRUNC Function

- 2 minutes to read

Returns a number truncated to the specified number of digits.

### Syntax syntax

TRUNC (** *number* **, ** *numberofdigits* **) TRUNC (** *number* **, ** *numberofdigits* ** )

### ParameterParameters

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. |

### Return value

Numeric. Numeric.

### NotesRemarks

If *numberofdigits* is greater than 0, will *number**on 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 *number**left on numberofdigits* truncated from the decimal separator If *numberofdigits* is less than 0, *number* is truncated to *numberofdigits* to the left of the decimal.

### Example 1

TRUNC (123,654.2) TRUNC (123,654.2)

Returns 123.65. Returns 123.65.

### Example 2

TRUNC (123,654.0) TRUNC (123,654.0)

Returns 123, returns 123.

### Example 3

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