Home 
Search 
Today's Posts 
#1




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




How to round the numeric value?
"Salman Saeed" <Salman wrote in message ... Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 Use the RND function..... 
#3




How to round the numeric value?
=CEILING(A1,0.5)
 Regards Dave Hawley www.ozgrid.com "Salman Saeed" <Salman wrote in message ... Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 
#4




How to round the numeric value?
Mon, 26 Apr 2010 02:59:01 0700 from ?B?U2FsbWFuIFNhZWVk?= <=?
Utf8?B?U2FsbWFuIFNhZWVk?=: Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 I don't know what that is, but it's not rounding. If you're rounding to the nearest whole, 1.2 would round to .0 not 1.5. Even if you are rounding to the nearest half, 1.7 would round to 1.5. Instead of just giving examples, please state your what you're actually trying to accomplish.  Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... 
#5




How to round the numeric value?
"Stan Brown" wrote in message t... Mon, 26 Apr 2010 02:59:01 0700 from ?B?U2FsbWFuIFNhZWVk?= <=? Utf8?B?U2FsbWFuIFNhZWVk?=: Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 I don't know what that is, but it's not rounding. If you're rounding to the nearest whole, 1.2 would round to .0 not 1.5. Even if you are rounding to the nearest half, 1.7 would round to 1.5. The OP could certainly use ROUNDUP on the 1.7 value, but the only way of making 1.2 show as 1.5 (AFAIK) would be to use an IF statement.. 
#6




How to round the numeric value?
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 addin 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 
#7




How to round the numeric value?
I think you need =ROUND(A2/0.5,0)*0.5
Here are examples of results from CEIL, MROUND and ROUND number =CEILING(A2,0.5) =MROUND(A2,0.5) =ROUND(A2/0.5,0)*0.5 1.45 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.7 2 1.5 1.5 1.9 2 2 2 2 2 2 2 2.1 2.5 2 2 2.45 2.5 2.5 2.5 2.5 2.5 2.5 2.5 best wishes  Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Salman Saeed" <Salman wrote in message ... Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 
#8




How to round the numeric value?
"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 addin 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 
#9




How to round the numeric value?
"Bernard Liengme" wrote:
I think you need =ROUND(A2/0.5,0)*0.5 [....] number =CEILING(A2,0.5) =MROUND(A2,0.5) =ROUND(A2/0.5,0)*0.5 [....] 1.7 2 1.5 1.5 But Saeed said that 1.7 should become 2. So by your own examples, CEILING is the only one of those 3 formulas that works for both examples that Saeed gave. (However, Saeed might have misrepresented his requirements.) Of course, Saleed could use ROUNDUP(A1*2,0)/2, which should be functionally equivalent to CEILING(A1,0.5). I say "should be" because with Excel, one can never be sure. Sh*t happens! ;)  original message  "Bernard Liengme" wrote in message ... I think you need =ROUND(A2/0.5,0)*0.5 Here are examples of results from CEIL, MROUND and ROUND number =CEILING(A2,0.5) =MROUND(A2,0.5) =ROUND(A2/0.5,0)*0.5 1.45 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.7 2 1.5 1.5 1.9 2 2 2 2 2 2 2 2.1 2.5 2 2 2.45 2.5 2.5 2.5 2.5 2.5 2.5 2.5 best wishes  Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Salman Saeed" <Salman wrote in message ... Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0 
#10




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 addin 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 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Find and Return Numeric Label based on (Numeric Value) Criterion  Excel Worksheet Functions  
Numeric in Text to convert back to the form of Numeric for VLookup Purposes  Excel Discussion (Misc queries)  
Match Single Numeric Criteria and Return Multiple Numeric Labels  Excel Worksheet Functions  
Match Single Numeric Criteria and Return Multiple Numeric Labels  Excel Worksheet Functions  
How do I ROUND() round off decimals of a column dataset?  Excel Worksheet Functions 