rounding to the nearest half ( .5)

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
 
G

Guest

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 formulas 5
advice on rounding or ceilng a 24 hour time value 3
Round to nearest whole number 5
Rounding 3
rounding to nearest .5 in vba 12
round to nearest 30-minute interval 2
Format cell to the nearest 100 4
How to round down to nearest 5 minutes, time calc? 6

Top