How do you round to 0.5 in excel

[Guest]

In some instances I need to round the results of calculations to the nearest
0.5 before continuing to the next stage

 

[Tom Ogilvy]

=ROUND(D2*2,0)/2

 

[Ron Rosenfeld]

In some instances I need to round the results of calculations to the nearest
0.5 before continuing to the next stage

With the Analysis Tool Pak installed:

=MROUND(A1, 0.5)

Without the ATP installed:

=ROUND(A1/0.5,0)*0.5

--ron