<div>
along the same lines<br />
<br />
=ROUND(A1/.5,0)*.5
</div>


<div>
thanks for the quick responses - can't believe I didn't think of that!
</div>


thanks for the quick responses - can't believe I didn't think of that!

<div>
thank you for the points and grade and welcome to EE :)
</div>


thank you for the points and grade and welcome to EE :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to round some certain values in a spreadsheet to the nearest 0.5. Is this possible? I seem only to be able to find the ROUND() and ROUNDUP() functions.<br />
<br />
Would greatly appreciate any help,<br />
<br />
thanks
</div>
</div>


Hi,

I need to round some certain values in a spreadsheet to the nearest 0.5. Is this possible? I seem only to be able to find the ROUND() and ROUNDUP() functions.

Would greatly appreciate any help,

thanks

How do I round  to nearest 0.5 in Excel?

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.