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
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
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
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:
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,
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