Thread: Rounding up or down in the same formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack L. Hyman Jack L. Hyman is offline
external usenet poster
  
Posts: 1
Default Rounding up or down in the same formula
How do I create a single formula to either round up or down the result of my
formula to the nearest "9"?
i.e.
843 = 839
845 = 849
etc., etc.
Thanks,
Jack
Reply With QuoteReply With Quote