Re: $$Excel-Macros$$ Round The Value as User Defined.

It's only my pleasure, On Thu, Jul 12, 2012 at 3:00 PM, jmothilal wrote: > i learn lot of command, thanks noorainansari > sir. > > > On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI > wrote: > >> Dear Ashish, >> >> You can also use.. >> >> *=ROUND(A2/5,0)*5 >> *

Re: $$Excel-Macros$$ Round The Value as User Defined.

i learn lot of command, thanks noorainansari sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI wrote: > Dear Ashish, > > You can also use.. > > *=ROUND(A2/5,0)*5 > * > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspo

Re: $$Excel-Macros$$ Round The Value as User Defined.

Dear Ashish, You can also use.. *=ROUND(A2/5,0)*5 * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara wrote: > Dear experts, > > I want to round the value in following condition. > If the value is 148,149,

Re: $$Excel-Macros$$ Round The Value as User Defined.

Dear Ashish, Please use Mround(A1,5) Sent from BlackBerry® on Airtel -Original Message- From: Ashish Bhalara Sender: excel-macros@googlegroups.com Date: Thu, 12 Jul 2012 09:35:09 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Round The Value as User Defined. Dea