View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Rounding down an average

Hi folks,

I've got a workbook with 20+ worksheets. In each worksheet, I'm doing an
average on all entries in column B =AVERAGE(B:B) . The range of cells in the
average could be 1 cell to 50 cells.

I'd like to round down that average, but am having difficulty getting any
variations of formulas to work.

Thanks,

Bob