Thread: On Excel I need to round up in tens of thousands
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default On Excel I need to round up in tens of thousands
One way:

=CEILING(A1,10000)



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

--

Dave Peterson
Reply With QuoteReply With Quote