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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---