Thread: Rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
  
Posts: 125
Default Rounding
=CEILING(A1,1000)

-John

"EC" wrote:

How would I round (41,568.00) to (42,000.00)?
Reply With QuoteReply With Quote