rounding formula

[Joel Allen]

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

 

[Guest]

=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'

 

[Guest]

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

 

[Joel Allen]

Thank you, the ToolPak fixed it!

-Joel

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