View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Mac John Mac is offline
external usenet poster
 
Posts: 13
Default Rounding averages

If I am averaging a set of data and only want the
answer to have the decimal place of either .1, .5, or .9 how can I round off
the answer (either up or down) to the nearest of those required decimal
places?
Thanks for any help!