View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Guy[_2_] Guy[_2_] is offline
external usenet poster
 
Posts: 47
Default Sums divisible by 12

I'd like a cell, thats adding cells, to round up or down to equate to a
whole number divisible by 12. One example would be a cell formal equaling 16,
I would want to round down to indicate only 12, and in another example a cell
may equal 21 and I would want to round up to 24. I'm building a spreadsheet
dealing with percentages, but need my outcome to be divisible by 12. Is there
anyone out there that can help? Id really appreciate it.--
Thanks,
Guy