Re: $$Excel-Macros$$ Rounding value of six digit

Thanks Asa for very useful information.. On Sat, May 5, 2012 at 7:14 AM, Asa Rossoff wrote: > Hi Shekhar, > > ** ** > > Either of these: > > =ROUNDDOWN(A1,-3) > > =MROUND(A1-500,1000) > > ** ** > > If you wanted to round to the nearest multiple of 1000, instead of > rounding down

Re: $$Excel-Macros$$ Rounding value of six digit

Asa and Maries, Thanks so much for providing the formulas. I was looking for the same kind of formulas. Thanks Shekhar Sharma On Sat, May 5, 2012 at 6:26 PM, Maries wrote: > Try this too, > > =QUOTIENT(A1,1000)*1000 > > > On Sat, May 5, 2012 at 5:47 AM, Maries wrote: > >> *Asa, Good Informati

Re: $$Excel-Macros$$ Rounding value of six digit

Try this too, =QUOTIENT(A1,1000)*1000 On Sat, May 5, 2012 at 5:47 AM, Maries wrote: > *Asa, Good Information* > > > On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote: > >> Hi Shekhar, >> >> ** ** >> >> Either of these: >> >> =ROUNDDOWN(A1,-3) >> >> =MROUND(A1-500,1000)

Re: $$Excel-Macros$$ Rounding value of six digit

*Asa, Good Information* On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote: > Hi Shekhar, > > ** ** > > Either of these: > > =ROUNDDOWN(A1,-3) > > =MROUND(A1-500,1000) > > ** ** > > If you wanted to round to the nearest multiple of 1000, instead of > rounding down, you cou

RE: $$Excel-Macros$$ Rounding value of six digit

Hi Shekhar, Either of these: =ROUNDDOWN(A1,-3) =MROUND(A1-500,1000) If you wanted to round to the nearest multiple of 1000, instead of rounding down, you could use either of these: =ROUND(A1,-3) =MROUND(A1,1000) Functions used for/in rounding include: ROUND ROUNDUP ROUNDDOWN MRO

Re: $$Excel-Macros$$ Rounding value of six digit

Or you can use this =INT(ROUND(A1/1000,3))*1000 *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 10:11 PM, ╰» ℓαℓιт мσαнη wrote: > Hi > > please explain because the rounding of a number is based

Re: $$Excel-Macros$$ Rounding value of six digit

Hi please explain because the rounding of a number is based on some rules. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma wrote: > Hi Experts, > > Kindly help me with