Thread: Help with rounding formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Help with rounding formulas
On Tue, 5 Sep 2006 21:16:17 +0100, TriciaF
wrote:


I am trying to round a whole number to the nearest hundred ex 8490 needs
to be rounded to 8500. How do I do this?


=ROUND(A1,-2)


--ron
Reply With QuoteReply With Quote