Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Ashish Bhalara
Thanks all I get it exactly what i want. Ashish On Thu, May 10, 2012 at 6:09 PM, Waseem Saifi wrote: > =ROUNDDOWN(A1,0) > > > On Thu, May 10, 2012 at 5:26 PM, Maries wrote: > >> *=ROUNDUP(A1,0.1) >> * >> >> On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat wrote: >> >>> =ROUND(E12,0) >>> >>> Rega

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Waseem Saifi
=ROUNDDOWN(A1,0) On Thu, May 10, 2012 at 5:26 PM, Maries wrote: > *=ROUNDUP(A1,0.1) > * > > On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat wrote: > >> =ROUND(E12,0) >> >> Regards, >> Deepak Rawat >> >> >> >> On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >>

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Maries
*=ROUNDUP(A1,0.1) * On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat wrote: > =ROUND(E12,0) > > Regards, > Deepak Rawat > > > > On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara > wrote: > >> Dear expert, >> >> The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 >> to 125. >> >> M

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Deepak Rawat
=ROUND(E12,0) Regards, Deepak Rawat On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara wrote: > Dear expert, > > The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 > to 125. > > My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output > is 126 > > In short if

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Maries
Try it, *=INT(A1)+1 * On Thu, May 10, 2012 at 2:38 PM, Ashish Bhalara wrote: > Dear expert, > > The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 > to 125. > > My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output > is 126 > > In short if value contain an