$$Excel-Macros$$ Rounding error at 12 decimals

Group I have tried this subtraction in three installations of Excel on 3 machines. the results are peculiar and are only seems to occur at the 12 decimal place 9,131.00 =+C18-C20 8,751.00 380.000

RE: $$Excel-Macros$$ Rounding up or down

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rags R Sent: Tuesday, February 25, 2014 10:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rounding up or down Hi, Need formula for rounding up number (i.e. 307,077 to 307,100

$$Excel-Macros$$ Rounding up or down

Hi, Need formula for rounding up number (i.e. 307,077 to 307,100 & 310,000) or rounding down (i.e.304,044 to 304,000 & 300,000). Thanking you in advance. -- Best Regards Rags!!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Fac

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

> > FIXED > > TEXT > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma > *Sent:* Friday, May 04, 2012 8:19 AM > *To:* excel-macros@googlegroups.com >

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

>>> CEILING >>> >>> CEILING.PRECISE >>> >>> FLOOR >>> >>> FLOOR.PRECISE >>> >>> EVEN >>> >>> ODD >>> >>> INT**** >>> >>> TRUNC >>> >>>

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

; >> FLOOR >> >> FLOOR.PRECISE >> >> EVEN >> >> ODD >> >> INT >> >> TRUNC >> >> MOD >> >> LOG10 >> >> LOG >> >> ABS**** >> >> SIGN

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

FIXED > > TEXT > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma > *Sent:* Friday, May 04, 2012 8:19 AM > *To:* excel-macros@googlegroups.com >

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

@googlegroups.com Subject: $$Excel-Macros$$ Rounding value of six digit Hi Experts, Kindly help me with rounding a value of six digit. Example: Cell A1 has value as : 59687 I want a formula available in excel to convert this value into 59000. I have used =ROUND(A1/1000,0)*1000

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

Re: $$Excel-Macros$$ rounding off problem

Hi, ** *Try it in Userform:* Private Sub CommandButton1_Click() TextBox2.Text = WorksheetFunction.Ceiling((Val(TextBox1.Text) * 0.03) - 0.8, 10) End Sub Regards, MARIES. On Wed, Feb 29, 2012 at 2:58 PM, Shankar Bheema wrote: > Dear Experts > > The above attached file contains an userform for r

$$Excel-Macros$$ rounding off problem

Dear Experts The above attached file contains an userform for rounding off of the value if the 3% of the given value comes to more than multiple of 10 except the fraction that value should be rounded off to the nearest multiple of 10 ex. if the value of 3% comes to 660.01 or 660.50 or 660.99 th

Re: $$Excel-Macros$$ Rounding Numbers

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ rounding off to nearest multiple of 10

, January 5, 2012 6:08:51 AM Subject: $$Excel-Macros$$ rounding off to nearest multiple of 10 Dear experts I am using excel vba.  I want to round off an amount to its nearest multiple of 10. eg :  251.10  (here fraction should not be considered only the whole number which has to be rounded off to

Re: $$Excel-Macros$$ rounding off to nearest multiple of 10

Hi, User following formula: =MROUND(A2, 10) Check following details for more details http://office.microsoft.com/en-us/excel-help/round-a-number-HP003056144.aspx Regards, Swapnil. On Thu, Jan 5, 2012 at 4:38 PM, Shankar Bheema wrote: > Dear experts > > I am using excel vba. I want to round o

$$Excel-Macros$$ rounding off to nearest multiple of 10

Dear experts I am using excel vba. I want to round off an amount to its nearest multiple of 10. eg : 251.10 (here fraction should not be considered only the whole number which has to be rounded off to its nearest multiple of 10 i.e. 260) 252 = 260 but 250 remains 250 Pls do reply -- FORUM

RE: $$Excel-Macros$$ Rounding Method

Thanx to all experts to answer me about my solution. Date: Wed, 9 Nov 2011 21:41:55 +0530 Subject: Re: $$Excel-Macros$$ Rounding Method From: ms.exl.lear...@gmail.com To: excel-macros@googlegroups.com Hi Mothilal, Yours is the exact and simplified solution. In fact, I forgot that

Re: $$Excel-Macros$$ Rounding Method

Hi Mothilal, Yours is the exact and simplified solution. In fact, I forgot that function and I was unable to recollect it while replying to the OP's question. But, your reply helped me to recall it. Thanks Dude... --- Ms.Exl.Learner --- On Wed, Nov 9, 2

Re: $$Excel-Macros$$ Rounding Method

use this command =floor(a1,5) Mothilal.J[image: image.png] On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote: > Dear Experts, > > I want rounding method in excel 2003 > when i typed 124.90 the rounding should come 120 & > when i typed 125.10 the rounding should come 125 & > when i type

Re: $$Excel-Macros$$ Rounding Method

Hi Sajid, Refer the reply given to another post for the same subject. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:10 PM, Advocate kbj wrote: > Dear Experts, > > I want rounding method in excel 2003 > when i typed 124.90 the rounding should come 120 &

$$Excel-Macros$$ Rounding Method

Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 & when i typed 125.10 the rounding should come 125 & when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon -- FORUM RULES (925+ members alrea

Re: $$Excel-Macros$$ Rounding method

Hi, Assume that your input data is A2 cell and apply the below formula in B2 cell. =A2-MOD(A2,5) Refer the attachment for details. --- Ms.Exl.Learner --- On Wed, Nov 9, 2011 at 2:11 PM, SAJID MEMON wrote: > Dear Experts, > > I want rounding method in

$$Excel-Macros$$ Rounding method

Dear Experts, I want rounding method in excel 2003 when i typed 124.90 the rounding should come 120 & when i typed 125.10 the rounding should come 125 & when i typed 129.90 the rounding should come 125 5 digits upward or downward rounding Regards Sajid Memon

Re: $$Excel-Macros$$ rounding to next higher rupee

ya its working. amazing. thank you so much On Wed, Sep 7, 2011 at 9:48 PM, NOORAIN ANSARI wrote: > see if it help > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ rounding to next higher rupee

see if it help -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 7, 2011 at 7:22 PM, Shankar Bheema wrote: > I am attaching an excel file with i

RE: $$Excel-Macros$$ rounding to next higher rupee

: excel-macros@googlegroups.com Objet : $$Excel-Macros$$ rounding to next higher rupee I am attaching an excel file with inserted userform. I have given command button to roundoff the figure in textbox1.text to the next higher rupee. I have given the code as textbox2.text=Round(val(textbox1

$$Excel-Macros$$ rounding to next higher rupee

I am attaching an excel file with inserted userform. I have given command button to roundoff the figure in textbox1.text to the next higher rupee. I have given the code as textbox2.text=Round(val(textbox1.text),0) but its returning wrong result. if i have given 100.1 in textbox1.text the resu

Re: $$Excel-Macros$$ Rounding

hth Paul From: BMFinance To: MS EXCEL AND VBA MACROS Sent: Fri, April 16, 2010 6:02:59 AM Subject: $$Excel-Macros$$ Rounding Hi all, I have a large spreadsheet file that has a lot of links and totals in it.  Unfortuantly the totals have a lot of rounding errors.  I can fix this by going into

$$Excel-Macros$$ Rounding

Hi all, I have a large spreadsheet file that has a lot of links and totals in it. Unfortuantly the totals have a lot of rounding errors. I can fix this by going into every cell and typing =Round(***,0). The only thing is that this would take me for ever. Is there a way to highlight a larg