Re: $$Excel-Macros$$ Rounding Numbers

2012-02-22 Thread Jayaprakash S
Thanks a Ton Maries!!! you made the formula so simple :-) cheers Jp. On Wed, Feb 22, 2012 at 2:48 PM, Maries wrote: > Hi, > > Subtract 0.1 from your value and Try Rount formula. > > =ROUND(A1-0.1,0.2) > > Regards, > > MARIES > > On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI > wrote: >> >> D

Re: $$Excel-Macros$$ Rounding Numbers

2012-02-22 Thread Maries
On Wed, Feb 22, 2012 at 1:18 PM, Maries wrote: > Hi, > > Subtract 0.1 from your value and Try Rount formula. > > *=ROUND(A1-0.1,0.2)* > > Regards, > > MARIES > > On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI > wrote: > >> Dear JP, >> >> See attached sheet.. >> >> On Wed, Feb 22, 2012 at 1:04

Re: $$Excel-Macros$$ Rounding Numbers

2012-02-22 Thread Maries
Hi, Subtract 0.1 from your value and Try Rount formula. *=ROUND(A1-0.1,0.2)* Regards, MARIES On Wed, Feb 22, 2012 at 12:14 PM, NOORAIN ANSARI wrote: > Dear JP, > > See attached sheet.. > > On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S > wrote: > >> Dear Experts, >> >> Good Noon. >> >> Need h

Re: $$Excel-Macros$$ Rounding Numbers

2012-02-22 Thread Jayaprakash S
Thanks Dear Noorain, superb !! =ROUND(MROUND(A1,0.4),0.5) - this formula also works :-) Mr. Sanjib - It is not working per my requirement - thank u for your effort.. cheers JP. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of

Re: $$Excel-Macros$$ Rounding Numbers

2012-02-22 Thread NOORAIN ANSARI
Dear JP, See attached sheet.. On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of numbers based on the decimal through a > formula... > > the criteria for roudning is : > > a) Less than or equal to 0.5 should get round down to prec

Re: $$Excel-Macros$$ Rounding Numbers

2012-02-21 Thread Sanjib Chatterjee
Dear jayaprakash s, You can use the below mentioned formula ROUND(A1,-0.2) sanjib On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of numbers based on the decimal through a > formula... > > the criteria for roudning is : > > a) L

$$Excel-Macros$$ Rounding Numbers

2012-02-21 Thread Jayaprakash S
Dear Experts, Good Noon. Need help on rounding up of numbers based on the decimal through a formula... the criteria for roudning is : a) Less than or equal to 0.5 should get round down to preceeding multiple of Ten (10.1 to 10.5 should be rounded to 10) b) Greater than or equal to 0.6 should g