in access, round up to nearest fraction(.5)

S

Stephengw

In MS-Access, How do I round a formula result up to the nearest fraction
(Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7
rounds up to 2
 
D

Daryl S

Stephengw -

Multiply the value by two, then round to no decimal places, then divide by
two.

=Round(2*[YourValue],0)/2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a word to a numerical field 0
round to nearest 5 2
Round up or down to nearest 5, but not 10 2
I need to always Round UP if greater than zero at all. HOW? 9
Need help removing extra TOC text from number lists used as TOC levels 0
Round number subject to it's value 1
rounding to nearest .5 in vba 12
rounding up to nearest specified whole number 1

Top