rounding formula
 

Hello,

When a cell is 28.32, I need it to round to the nearest 0.5, so for example,
this one should equal 28.50. I tried MRound and Roundup and couldn't get it
to work.

Thanks
-Joel

=MROUND(28.32,.5) worked for me, output 28.5

What number did it output for you? If you got an error when you tried to
use it you have to install the Analysis ToolPak... Tools-Add-Ins-Check
'Analysis ToolPak'


--
Regards,
Dave
<!--


"Joel Allen" wrote:

Hello,

When a cell is 28.32, I need it to round to the nearest 0.5, so for example,
this one should equal 28.50. I tried MRound and Roundup and couldn't get it
to work.

Thanks
-Joel

You can also use this formula:
=ROUND(28.32/0.5,0)*0.5


--
Regards,
Dave
<!--


"David Billigmeier" wrote:

=MROUND(28.32,.5) worked for me, output 28.5

What number did it output for you? If you got an error when you tried to
use it you have to install the Analysis ToolPak... Tools-Add-Ins-Check
'Analysis ToolPak'


--
Regards,
Dave
<!--


"Joel Allen" wrote:

Hello,

When a cell is 28.32, I need it to round to the nearest 0.5, so for example,
this one should equal 28.50. I tried MRound and Roundup and couldn't get it
to work.

Thanks
-Joel

Thank you, the ToolPak fixed it!

-Joel

"David Billigmeier" wrote in
message ...
You can also use this formula:
=ROUND(28.32/0.5,0)*0.5


--
Regards,
Dave
<!--


"David Billigmeier" wrote:

=MROUND(28.32,.5) worked for me, output 28.5

What number did it output for you? If you got an error when you tried to
use it you have to install the Analysis ToolPak... Tools-Add-Ins-Check
'Analysis ToolPak'


--
Regards,
Dave
<!--


"Joel Allen" wrote:

Hello,

When a cell is 28.32, I need it to round to the nearest 0.5, so for
example,
this one should equal 28.50. I tried MRound and Roundup and couldn't
get it
to work.

Thanks
-Joel