Round vs Rounddown vs Rounddown Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use ROUND, ROUNDUP, and ROUNDDOWN formula in Excel step by step with simple examples and video speak Khmer.

You ever want to round number in Excel? Maybe you want to round to nearest whole number, always round up (like for calculating pizza slices), or always round down (like for limiting discounts)? Excel have three functions for this: ROUND, ROUNDUP, and ROUNDDOWN.

Let's look at how to use all three functions below.

1. How to Use ROUND Formula in Excel

ROUND function rounds a number to specified number of digits. If the digit after the rounding position is 5 or greater, it rounds up. If it's less than 5, it rounds down.

Formula Syntax:

=ROUND(number, num_digits)

Examples:

• =ROUND(10.85, 0) ➔ 11 (Because .8 is ≥ .5, it rounds up to 11)
• =ROUND(10.45, 0) ➔ 10 (Because .4 is < .5, it rounds down to 10)
• =ROUND(10.856, 2) ➔ 10.86 (Rounds to 2 decimal places)

Watch video below to see step by step guide in Khmer:

2. How to Use ROUNDUP Formula in Excel

ROUNDUP function always rounds a number UP, away from zero. It doesn't matter if the decimal is .1 or .9, it will always go higher.

Formula Syntax:

=ROUNDUP(number, num_digits)

Examples:

• =ROUNDUP(10.85, 0) ➔ 11 (Always rounds up!)
• =ROUNDUP(10.45, 0) ➔ 11 (Even .4 rounds up to 11!)
• =ROUNDUP(10.856, 2) ➔ 10.86

3. How to Use ROUNDDOWN Formula in Excel

ROUNDDOWN function always rounds a number DOWN, towards zero. It ignores the decimal and goes lower.

Formula Syntax:

=ROUNDDOWN(number, num_digits)

Examples:

• =ROUNDDOWN(10.85, 0) ➔ 10 (Always rounds down!)
• =ROUNDDOWN(10.45, 0) ➔ 10 (Even .9 rounds down to 10!)
• =ROUNDDOWN(10.856, 2) ➔ 10.85 (Rounds down to 2 decimal places)

Watch video below for full guide in Khmer:

4. ROUND + ROUNDUP + ROUNDDOWN in Excel

💡 Quick Tip:

• Use ROUND for normal rounding (like grades or prices).
• Use ROUNDUP when you need to make sure you have enough (like ordering boxes, extra pizza slices, or calculating shipping cost).
• Use ROUNDDOWN when you want to remove decimals or limit amount (like removing cents, or calculating budget).

📚 Useful Resources

• Sum vs Sumproduct Function in Excel (Video in Khmer)
• INT vs TRUNC Function in Excel (Video in Khmer)
• 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)