Int vs Trunc Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use INT and TRUNC formula in Excel step by step with simple examples and video speak Khmer.

You ever want to remove decimals from numbers in Excel? For example, turn 10.85 into 10? Excel have two formulas for this: INT (Integer) and TRUNC (Truncate). They look like they do the same thing for positive numbers, but they behave very differently when working with negative numbers!

Let's look at how to use both function below.

1. How to Use INT Formula in Excel

INT function rounds a number DOWN to the nearest integer.

Formula Syntax:

=INT(number)

Examples:

• =INT(10.85) ➔ 10 (Rounds positive number down to 10)
• =INT(-10.85) ➔ -11 (Rounds negative number down to -11 because -11 is smaller than -10.85!)

Watch video below for step by step guide in Khmer:

2. How to Use TRUNC Formula in Excel

TRUNC function cuts off (truncates) decimal places without rounding. You can also specify how many decimal places to keep.

Formula Syntax:

=TRUNC(number, [num_digits])

Examples:

• =TRUNC(10.85) ➔ 10 (Simply drops decimals)
• =TRUNC(-10.85) ➔ -10 (Simply drops decimals, keeping -10!)
• =TRUNC(10.856, 2) ➔ 10.85 (Keeps 2 decimal places without rounding)

Watch video below for step by step guide in Khmer:

💡 Quick Tip:

• For positive numbers, INT and TRUNC give exact same result (e.g., INT(5.9) = TRUNC(5.9) = 5).
• For negative numbers, INT rounds down away from zero (INT(-5.9) = -6), while TRUNC just cuts off decimals towards zero (TRUNC(-5.9) = -5).
• Use TRUNC when you want to keep specific number of decimal places without rounding.

📚 Useful Resources

• Sum vs Sumproduct Function in Excel (Video in Khmer)
• How to use MIN vs MAX and SMALL vs LARGE Functions in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know
• How to Allow Input Number and Text Only in Excel with Data Validation
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)