Round up/down at 1.5

[Ross191]

Hello,

I'm looking to create an excel function which will round down anything based on .5 (i.e. 1.5, 2.5.3.5, etc.) and round everything else up. Can you assist as I can't figure out the related function.

Thank you in advance!

 

[Asala42]

If I read you right, an if-statement can do it

=IF(MOD(A2,1)<=0.5,FLOOR(A2,1),CEILING(A2,1))

This will round down when the decimal is .5 or less, otherwise it will round up.

 

[Michael M]

Maybe also.....

=MROUND(A1-0.001,1)

 

[barry houdini]

....or

=CEILING(A1-0.5,1)

 

[Ross191]

That worked Asala. Thank you!