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
Thanks paul but it's not working.
On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner schreiner_p...@att.netwrote:
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
, 2013 11:12:18 AM
Subject: Re: $$Excel-Macros$$ Required Roundup Formula.
Thanks paul but it's not working.
On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner schreiner_p...@att.net wrote:
Here's what I would do:
since you're wanting to round to 5 or 10's,
I'd multiply the number
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;
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 pritiverma1...@gmail.comwrote:
Hi Kuldeep
I think this formula fullfil your requirement.
=ROUNDUP((A2*2)/10,0)*10/2
Thanks *Paul Sam*, your formula is working fine.
Regards,
Kuldeep Singh
On Tue, Apr 16, 2013 at 11:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
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