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 ashishbhalar...@gmail.comwrote: Dear experts, I want to round the value in following condition. If

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

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

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

It's only my pleasure, On Thu, Jul 12, 2012 at 3:00 PM, jmothilal gjmothi...@gmail.com wrote: i learn lot of command, thanks noorainansarihttp://www.noorainansari.com/ sir. On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, You can also use..

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

: $$Excel-Macros$$ Round The Value as User Defined. Dear experts, I want to round the value in following condition. If the value is 148,149,150,151,152, Output is 150. If the value is 153,154,155,156,157, Output is 155. If the value is 158,159,160,161,162, Output is 160. Kindly know me how its