Re: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Kuldeep Singh
Thanks *Paul & Sam*, your formula is working fine. Regards, Kuldeep Singh On Tue, Apr 16, 2013 at 11:23 PM, Sam Mathai Chacko wrote: > Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5) > should be fine > > Regards, > Sam Mathai Chacko > > > On Tue, Apr 16, 2013 at 8:46 PM, Pr

Re: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Sam Mathai Chacko
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5) should be fine Regards, Sam Mathai Chacko On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma wrote: > Hi Kuldeep > > I think this formula fullfil your requirement. > > =ROUNDUP((A2*2)/10,0)*10/2 > > Regards > > Pr

RE: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Priti_verma
Hi Kuldeep I think this formula fullfil your requirement. =ROUNDUP((A2*2)/10,0)*10/2 Regards Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 16 April 2013 8:17 To: excel-macros@googlegroups.com; excelvbacli...@googleg

Re: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Paul Schreiner
u can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kuldeep Singh To: "excel-macros@googlegroups.com" Sent: Tue, April 16, 2013 11:12:18 AM Subject: Re:

Re: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Kuldeep Singh
Thanks paul but it's not working. On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner wrote: > Here's what I would do: > since you're wanting to round to 5 or 10's, > I'd multiply the number by 2, then you're technically rounding by 10's or > 20's, > which, is the same as rounding by 10's. > > Then,

Re: $$Excel-Macros$$ Required Roundup Formula.............

2013-04-16 Thread Paul Schreiner
Here's what I would do: since you're wanting to round to 5 or 10's, I'd multiply the number by 2, then you're technically rounding by 10's or 20's, which, is the same as rounding by 10's. Then, divide the number by 10 (which moves the decimal point) and round the number to an even integer. By mu