📊 Excel-12

✨ Project Description

Excel-12 is a guide to rounding numbers in Excel. This repository provides clear explanations, practical examples, and screenshots for each formula.

📁 Goal: Help you master all rounding options in Excel for more accurate and flexible calculations—suitable for all skill levels!

---

📚 Table of Contents

• ROUND
• ROUNDUP
• ROUNDDOWN
• Show Fewer Decimals Without Rounding
• INT
• TRUNC
• Decimal Part
• MROUND, CEILING, FLOOR
• EVEN
• ODD
• Screenshots
• Requirements
• Author

---

🔵 ROUND

The ROUND function in Excel rounds a number to a specified number of digits. The ROUND function rounds up or down. 1, 2, 3 and 4 get rounded down. 5, 6, 7, 8 and 9 get rounded up.

• Round a number to three decimal places:

  

• Round a number to two decimal places:

  

• Round a number to the nearest integer:

  

• Round a number to the nearest 10:

  

• Round a number to the nearest 100:

  

• Round a number to the nearest 1000:

  

---

🔵 ROUNDUP

The ROUNDUP function in Excel always rounds a number up (away from zero). 1, 2, 3, 4, 5, 6, 7, 8 and 9 get rounded up.

• Round a number up to three decimal places:

  

• Round a number up to the nearest 1000:

  

---

🔵 ROUNDDOWN

The ROUNDDOWN function in Excel always rounds a number down (toward zero). 1, 2, 3, 4, 5, 6, 7, 8 and 9 get rounded down.

• Round a number down to three decimal places:

  

• Round a number down to the nearest integer:

  

---

🔵 Show Fewer Decimals Without Rounding

If you round a number, you lose precision. If you don't want this, show fewer decimal places without changing the number itself.

Use the Decrease Decimal button on the Home tab to show fewer decimal places in Excel.

Result:

(Note: the formula bar shows that cell A1 still contains the value 5.375.)

---

🔵 INT

The INT (Integer) function rounds a number down to the nearest integer (negative numbers become more negative).

---

🔵 TRUNC

The TRUNC (Truncate) function always chops off decimals.

(Note: The TRUNC function can keep any number of decimals. Simply use the second argument to specify how many decimals you want to keep.)

---

🔵 Decimal Part

To return just the decimal part of a number, use the following formula:

---

🔵 MROUND, CEILING, FLOOR

• MROUND: Round a number to the nearest multiple of 5:

  

• CEILING: Same as MROUND but always rounds up.

• FLOOR: Same as MROUND but always rounds down.

---

🔵 EVEN

The EVEN function rounds a positive number up to the nearest even integer.
The EVEN function rounds a negative number down to the nearest even integer.

---

🔵 ODD

The ODD function rounds a positive number up to the nearest odd integer.
The ODD function rounds a negative number down to the nearest odd integer.

The ISEVEN function returns TRUE if a number is even and FALSE if a number is odd.
The ISODD function returns TRUE if a number is odd and FALSE if a number is even.

---

📷 Screenshots

You can find all screenshots in the /Screenshots folder.

---

ℹ️ Requirements

• Microsoft Excel (recommended: 2021/365 for all features shown)
• Windows OS

---

👨‍💻 Author

Project and documentation by Kuba27x
Repository: Kuba27x/Excel-12

---