Thread: Rounding to every 5th whole number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LHS LHS is offline
external usenet poster
  
Posts: 1
Default Rounding to every 5th whole number
I have a pivot table that is giving currency values. I need a separate
column with these values rounded to the nearest fifth. For example 13,576.90
needs to round to 13,575 or 389.10 needs to round to 390.
Reply With QuoteReply With Quote