How to Rounddown and Roundup in 1cell

[Khoo Ming Wei]

Good day. For an example I would to roundup figure above decimal .75 but in between if the figure below decimal .75, I would like to rounddown. May I know what equation I should use in order to have this effect.

Thank you

best Regard

Mr Khoo

[#2]

Hi,

Could be

=IF(MOD(A1,1)<0.75,FLOOR(A1,1),CEILING(A1,1))

[#3]

Thank you. The format is useful.