gud

2009/6/24 Deepak Gupta <dpk1...@gmail.com>

>
> Dear ,
>
> use function @MROUND(FIGURE,50)
>
>
> DEEPAK
>
> On 6/23/09, Dharmendra Kumar <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
> >
> > Kindly go through the attached file.
> >
> > 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
> >
> > >
> >
>
> >
>


-- 
Moksh

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