Round a decimal to the nearest of 0.25, 0.50, 0.75, the whole number

[aarthimaa]

Hi every one.


While converting Deci meter to square feet, it will display the results in decimals those to be rounded to the nearest of 0.25, 0.50, 0.75 , the whole number.


Thanks in Advance

 

[Hui]

Multiply by 4

Add 0.5

Take integer part

Divide by 4


eg:

=INT(A1*4+0.5)/4

 

[aarthimaa]

Really Thank you so much

 

[murugaraj]

Hui, that's really elegant. I wonder how you could have thought that.

 

[Nunes]

what about

=ROUND( A1/0.25 , 0) * 0.25

 

[Jefrey]

AWESOME! THANKS! )