ExcelBanter - how do i round to the nearest 0.5 in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i round to the nearest 0.5 in excel (https://www.excelbanter.com/excel-discussion-misc-queries/83165-how-do-i-round-nearest-0-5-excel.html)

bigred

how do i round to the nearest 0.5 in excel

Dave Peterson

how do i round to the nearest 0.5 in excel

One way:
=ROUND(A1*2,0)/2

bigred wrote:

--

Dave Peterson

All times are GMT +1. The time now is 12:02 AM.