All Round Function in Excel

All Round Function in Excel

 

Round Function

 

=ROUND(A2,2)

 

	A	B
1	Number	Round No.
2	102.1234	102.12
3	136.2564	136.26
4	456.2567	456.26
5	693.4785	693.48

 

Roundup Function

 

=ROUNDUP(A2,0)

	A	B
1	Number	Roundup No.
2	102.1234	103
3	136.2564	137
4	456.2567	457
5	693.4785	694

 

Rounddown Function

 

=ROUNDDOWN(A2,0)

 

	A	B
1	Number	Rounddown No.
2	102.1234	102
3	136.2564	136
4	456.2567	456
5	693.4785	693

 

Mround Function

 

=MROUND(A2,50)

 

	A	B
1	Number	Mround No.
2	102.1234	100
3	136.2564	150
4	456.2567	450
5	693.4785	700