rounddown

The ROUNDDOWN function in Excel is used to round a number down toward zero, to a specified number of decimal places. Below are 10 examples of how to use the ROUNDDOWN function, including sample data and formulas.

---

1. Basic ROUNDDOWN

Formula:
=ROUNDDOWN(A1, 0)
Data:
A1 = 3.14159
Result:
3

---

2. ROUNDDOWN to 1 Decimal Place

Formula:
=ROUNDDOWN(A2, 1)
Data:
A2 = 5.678
Result:
5.6

---

3. ROUNDDOWN to 2 Decimal Places

Formula:
=ROUNDDOWN(A3, 2)
Data:
A3 = 12.3456
Result:
12.34

---

4. ROUNDDOWN with Negative Decimal Places (Rounding to the Left of the Decimal)

Formula:
=ROUNDDOWN(A4, -1)
Data:
A4 = 123.45
Result:
120

---

5. ROUNDDOWN with Negative Decimal Places (Rounding to Hundreds)

Formula:
=ROUNDDOWN(A5, -2)
Data:
A5 = 987.65
Result:
900

---

6. ROUNDDOWN with a Formula Inside

Formula:
=ROUNDDOWN(A6/2, 0)
Data:
A6 = 15
Result:
7

---

7. ROUNDDOWN with a SUM Function

Formula:
=ROUNDDOWN(SUM(A7:B7), 1)
Data:
A7 = 10.25, B7 = 20.75
Result:
30.9

---

8. ROUNDDOWN with a Percentage

Formula:
=ROUNDDOWN(A8*1.15, 2)
Data:
A8 = 50.123
Result:
57.64

---

9. ROUNDDOWN with a Large Number

Formula:
=ROUNDDOWN(A9, -3)
Data:
A9 = 123456
Result:
123000

---

10. ROUNDDOWN with a Negative Number

Formula:
=ROUNDDOWN(A10, 1)
Data:
A10 = -7.89
Result:
-7.8

---

Summary Table

Example	Formula	Data	Result
1	=ROUNDDOWN(A1, 0)	3.14159	3
2	=ROUNDDOWN(A2, 1)	5.678	5.6
3	=ROUNDDOWN(A3, 2)	12.3456	12.34
4	=ROUNDDOWN(A4, -1)	123.45	120
5	=ROUNDDOWN(A5, -2)	987.65	900
6	=ROUNDDOWN(A6/2, 0)	15	7
7	=ROUNDDOWN(SUM(A7:B7), 1)	10.25, 20.75	30.9
8	=ROUNDDOWN(A8*1.15, 2)	50.123	57.64
9	=ROUNDDOWN(A9, -3)	123456	123000
10	=ROUNDDOWN(A10, 1)	-7.89	-7.8

---

These examples demonstrate the versatility of the ROUNDDOWN function in Excel. You can use it in various scenarios, such as financial calculations, data analysis, and more