On Excel I need to round up in tens of thousands Sorianop 28.09.2006 17:20:02 On Excel I need to round up to tens of thousands... e.g. 158000 to 160000 or 21500 to 30000... Does any one know this formula??? Thank You in advance

RE: On Excel I need to round up in tens of thousands Houston_Aimee 28.09.2006 17:34:01 Normally when you round to decimal places, the item after the comma is a positive: a "2" rounds to hundreths. But when you round on the "other side" of the decimal, you put it in as negative. -4 will take you to 10,000 place I believe. ex: =ROUND(cell_ref,-4) "Sorianop" wrote: [Quoted Text] > On Excel I need to round up to tens of thousands... > e.g. 158000 to 160000 > or 21500 to 30000... > Does any one know this formula??? > > Thank You in advance

Re: On Excel I need to round up in tens of thousands "PCLIVE" <pclive(RemoveThis)[ at ]cox.net> 28.09.2006 17:39:39 And if you want to get really complicated, you can use this: =IF(RIGHT(A1,4)="0000",A1,A1+(10000-RIGHT(A1,4))) But I like Aimee's solution better. Love the spelling too. Just like my daughter. Paul "Houston_Aimee" <Houston_Aimee[ at ]discussions.microsoft.com> wrote in message news:3A539881-E947-4321-AB7B-745297A0EB4A[ at ]microsoft.com... [Quoted Text] > Normally when you round to decimal places, the item after the comma is a > positive: a "2" rounds to hundreths. But when you round on the "other > side" > of the decimal, you put it in as negative. -4 will take you to 10,000 > place I > believe. > > ex: > =ROUND(cell_ref,-4) > > "Sorianop" wrote: > >> On Excel I need to round up to tens of thousands... >> e.g. 158000 to 160000 >> or 21500 to 30000... >> Does any one know this formula??? >> >> Thank You in advance

Re: On Excel I need to round up in tens of thousands Dave Peterson <petersod[ at ]verizonXSPAM.net> 28.09.2006 17:51:13 One way: =CEILING(A1,10000) Sorianop wrote: [Quoted Text] > > On Excel I need to round up to tens of thousands... > e.g. 158000 to 160000 > or 21500 to 30000... > Does any one know this formula??? > > Thank You in advance -- Dave Peterson