rounddown()

[lezawang]

Hi
While I understand roundup() function and it does make the name is round up because it round by by 1 but what I found that the name of Rounddown() function does not make any sense. It does not change anything just "trim" the decimal numbers, if I say rounddown(A1,2) this function will keep only 2 decimals and trim/cut the reset. Am I right to say that function only trim decimals? Thank you very much

Book1
	A	B	C	D
1			roudup	round down
2	6		6	6
3	4.654893		4.66	4.65
4	2.265063		2.27	2.26
5	8.406176		8.41	8.4
6	9.319267		9.32	9.31
7	4.155315		4.16	4.15
8	4.787648		4.79	4.78
9	7.968179		7.97	7.96
10	3.03492		3.04	3.03
11	7.58188		7.59	7.58
12	8.77386		8.78	8.77
Sheet1

Cell Formulas
Range	Formula
C2:C12	C2	=ROUNDUP(A2,2)
D2:D12	D2	=ROUNDDOWN(A2,2)

 

[Michael M]

It depends on what you want to ROUNDDOWN to.
If you want to roundown to the nearest whole number, you would use

=ROUNDDOWN(A1,0)

Have a look here for all the scenarios of the ROUNDDOWN function

ROUNDDOWN Function

The Excel ROUNDDOWN function returns a number rounded down to a given number of places. Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN rounds all numbers down.

exceljet.net

 

[Peter_SSs]

Rounddown() function does not make any sense.

To me it makes perfect sense.
Using your examples ..
ROUNDUP(..., 2) returns the closest 2-decimal place number that is greater than or equal to the original number
ROUNDDOWN(..., 2) returns the closest 2-decimal place number that is less than or equal to the original number