Frnd, You can use this formula =round(A1,-2), then it will convert to nearest 100.
On Wed, Jun 24, 2009 at 10:53 AM, Dilip Pandey <dilipan...@gmail.com> wrote: > 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 >> >> >> >> >> -- aJaY :) ®™ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
