Thanks Dilip,

Dave.
 


Date: Wed, 24 Jun 2009 15:39:43 +0530
Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or 
lower 00 Figures
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com


Hi Dave,
 
Below is what I found when I searched Excel 2003 help section for "MROUND 
function".
Please go through it.
 
Thanks,
==============================================================================================

==============================================================================================
MROUND
See Also
Returns a number rounded to the desired multiple.
If this function is not available, and returns the #NAME? error, install and 
load the Analysis ToolPak add-in.
How?


On the Tools menu, click Add-Ins. 
In the Add-Ins available list, select the Analysis ToolPak box, and then click 
OK. 
If necessary, follow the instructions in the setup program. 
Syntax
MROUND(number,multiple)
Number   is the value to round.
Multiple   is the multiple to which you want to round number.
Remark
MROUND rounds up, away from zero, if the remainder of dividing number by 
multiple is greater than or equal to half the value of multiple.
==============================================================================================
==============================================================================================


-- 
DILIP KUMAR PANDEY  
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Wed, Jun 24, 2009 at 2:49 PM, Dave Bonallack <davebonall...@hotmail.com> 
wrote:


Hi Dilip,
When I open your workbook (with XL2000), it functions as you say it should.
However, when I type in '=+MROUND(A3,100)' to any cell, I get a #NAME? error.
I don't see 'MROUND' in the function list, or the use of the '+'
Can you tell me what's happening please? 
Regards - Dave.



Date: Wed, 24 Jun 2009 13:23:51 +0530
Subject: $$Excel-Macros$$ Re: Plz. Help: Convert complex figures into higher or 
lower 00 Figures
From: dilipan...@gmail.com 

To: excel-macros@googlegroups.com





Hi ddp,
 
It is not as big as you have presented.  Try the below formula and you will 
have the required result.
 
=+MROUND(A3,100)
'where A3 is the reference
 
I have tested this on a workbook and same is attached herewith for your 
reference.
 
Thanks,
Dilipandey
-- 
DILIP KUMAR PANDEY  
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062

 


 
On Tue, Jun 23, 2009 at 11:07 PM, ddp <dharmendrakumar...@gmail.com> wrote:



Hi members,

Hope you all are doing well.

Please help me with a solution which, I am sure, will benefit others
too.

Problem:        It is very difficult to remember tones of figures

Solution:       It is easier to remember nearest lower/higher figures

Formula/function required:      If last two digits>50, convert the
entire
figure to higher 00 level and if last two digits<50, convert the
entire figure to lower 00 level

Sales Qty               Formula/function required, which will lead to

2723                              2700
2584                              2600
2358                              2400
147                              100
91547232                         91547200





I use Office 2007 at home and 2003 in office

I am well versed with excel but not much with VBA

Thanking you in advance.

Regards,
Dharmendra









Click here to find out more POP access for Hotmail is here!









_________________________________________________________________
Get the latest news, goss and sport Make ninemsn your homepage!
http://windowslive.ninemsn.com.au/article.aspx?id=813730
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to