Round / Roundup/ Rounddown not able to get my requirement..

[madhanji]

Dear Senior /Excel Masters,
i am aware of Round/Roundup/Rounddown functions.
here my value in cell is 72.7375
i need 72.75
i need incremental value from 72.7375+0.25 =73
so i need to round 72.7375 =72.75

Please help....

 

[MARK858]

Try

Book1
	A	B	C
1	72.7375		72.75
Sheet1

Cell Formulas
Range	Formula
C1	C1	=MROUND(A1,0.25)

 

[Toadstool]

Edited

 

[madhanji]

Dear Mark858 sir, S, it's perfect solution for my requirement..
i don't know MROUND function..
Thanks for learn new one with solution..

Happy Life.

 

[MARK858]

You're welcome