How do you round to 0.5 in excel
 

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

How do you round to 0.5 in excel
 

=ROUND(D2*2,0)/2

--
Regards,
Tom Ogilvy


"cathypault" wrote in message
...
In some instances I need to round the results of calculations to the
nearest
0.5 before continuing to the next stage

How do you round to 0.5 in excel
 

On Wed, 22 Sep 2004 16:29:05 -0700, "cathypault"
wrote:

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