rounding to nearest 5

[anandvarma]

i want round the numbers to nearest five look at the following example

Excel Workbook
	A	B
1	Data	Expected result
2	22.45	20
3	22.55	25
4	25.1	25
5	27.4	25
6	27.6	30
7	30	30
Sheet1

 

[VoG]

Try

=ROUND(A2/5,0)*5

 

[anandvarma]

Thanks Vog

now i got it

 

[Matty]

Try:

=MROUND(A2,5)

Matty