Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
How do I get my formula to stop rounding up | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |