Rounding to nearest .25

Rounding to nearest .25

Post by SGFua3Nvc » Thu, 16 Oct 2008 22:45:03


Is there something that will allow me to round decimals such as 0.14 to 0.25?
I know that Excel has a Ceiling function that works but I can't come up with
anything similar in Access. Any help will be appreciated.
 
 
 

Rounding to nearest .25

Post by Michel Wal » Thu, 16 Oct 2008 22:55:08


- int(- 4 * x ) / 4



should do, for x >= 0



Vanderghast, Access MVP

 
 
 

Rounding to nearest .25

Post by Allen Brow » Thu, 16 Oct 2008 23:22:49

Here's a bunch of information on rounding techniques for Access:
http://www.yqcomputer.com/

The section on rounding to the nearest 5 cents also has the 25c example.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.
 
 
 

Rounding to nearest .25

Post by SGFua3Nvc » Thu, 16 Oct 2008 23:36:01

Thank you very much. This helps a great deal........