I am looking for a way to round the decimal portion of numbers up or down to the nearest .25, .5, .7
Posted
by Charles Anderson
on Stack Overflow
See other posts from Stack Overflow
or by Charles Anderson
Published on 2010-05-24T21:48:39Z
Indexed on
2010/05/24
21:51 UTC
Read the original article
Hit count: 211
Filed under:
ms-access
If the decimal part is 0.1 to 0.12, it rounds down to the next lower integer If the decimal part is 0.13 to 0.37 it rounds to 0.25 If the decimal part is 0.38 to 0.62 it rounds to 0.5 If the decimal part is 0.63 to 0.87 it rounds to 0.75 If the decimal part is 0.88 or more, it rounds up to the next higher integer
© Stack Overflow or respective owner
