Forum Discussion
How to Rounddown and Roundup in 1cell
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
Hi,
Could be
=IF(MOD(A1,1)<0.75,FLOOR(A1,1),CEILING(A1,1))
Thank you. The format is useful.
