rounding to the nearest half ( .5)

  • Thread starter Thread starter Leaper
  • Start date Start date
L

Leaper

Hi
is it posible to use the rounding to round a calculation to the nearest
half,

ie 2.24 = 2
2.26 = 2.5 etc

Kev
 
Yes it is. In the round function specify the units rounded to after the
value being rounded

(ie FLOOR(B5,.5))
 

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

rounding to nearest .5 in vba 12
round to nearest 30-minute interval 2
in access, round up to nearest fraction(.5) 1
Round to the nearest half hour 3
Round up to nearest multiple of 5 3
rounding to the nearest 100 3
Adjusting time data to nearest ten minute block 2
Round to nearest whole number 5

Back
Top