round up to nearest 0.5 in excel

[Steve70]

How do you round up to nearest 0.5 in excel?

So for example,

3.2 should be rounded to 3
3.3 should be rounded to 3.5
3.6 rounded to 3.5
3.8 rounded to 4

Is there a function for this?

[jronaldlee]

oops - double post.

[jronaldlee]

Your question says round up to the nearest 0.5, but your example shows you rounding to the nearest 0.5.

For example, rounding to the nearest 0.5 means 3.1 becomes 3.0.
Rounding up to the nearest 0.5 means 3.1 becomes 3.5.

Assuming the value you wish to round is in cell A1, these formulae will do what you want to do:

To round to the nearest 0.5:

=ROUND(A1*2,0)/2

To round up to the nearest 0.5:

=ROUNDUP(A1*2,0)/2

[Steve70]

Thank you