View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default How to round the numeric value?

Quite right, thanks for the correction. I'd actually thought MRound()
rounded, but read something in Help that led me in the other direction -
quite possibly I was looking at CEILING() help and thinking MROUND().

As for what the OP really wants? Who knows, I think everyone is doing the
typical, reasonable thing -- interpreting based on example data/results
provided, which is often quite full of holes.

"Joe User" wrote:

"JLatham" wrote:
look at =MROUND(1.2,0.5)
Since MROUND() rounds up


I don't think so.

the effect in this case is the same as
CIELING(1.2,0.5).


I don't think so.

MROUND(1.2,0.5) is 1, whereas CEILING(1.2,0.5) is 1.5.

MROUND rounds; CEILING rounds up. Since the latter provides the result that
Saeed requested (based on his two examples), CEILING is the correct function
to use.

Of course, that begs the questions of whether the two examples sufficiently
demonstrate the kind of rounding that Saeed really wants, and whether his two
examples correctly reflect what he wants. I would like to have seen more
examples, notably 1.1 and 1.6.


----- original message -----

"JLatham" wrote:
In addition to what ozgrid.com provided (which will round UP to the next
nearest .5 boundary), look at
=MROUND(1.2,0.5)
Since MROUND() rounds up,the effect in this case is the same as
CIELING(1.2,0.5). Plus, MROUND() requires that the Analysis ToolPak add-in
be active/installed.

Just another alternative. You can also look at FLOOR() if you need to round
DOWN.

"Salman Saeed" wrote:

Kindly tell me that how can we round the numeric value?
Example: 1.2 = 1.5, 1.7 = 2.0