I want to be able to round a number in Excel to the nearest 1/2. In other words, if I have 3.04, I want that to round to 3.00, but if I have 3.45, I want that to round to 3.50 instead of 3.0. Is there any formula or combination of formulas that will let me do this?
