Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
getting numbers that are divisible by 4 | Excel Worksheet Functions | |||
Check if Equally Divisible | Excel Worksheet Functions | |||
Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
How get true response when numbers divisible by 12? | Excel Worksheet Functions | |||
how do an @if formula to meet criteria where x is divisible by 12 | Excel Worksheet Functions |