| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sums divisible by 12
You could use Analysis ToolPak add-in function MROUND to round to the nearest
12, e.g. =MROUND(A1,12) A1 can be a cell value or replace with another formula. Note: if you mean round the nearest 12% then change to =MROUND(A1,0.12) Without Analysis ToolPak =ROUND(A1/12,0)*12 Again, for rounding to the nearest 12% change to =ROUND(A1/12%,0)*12% "Guy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sums divisible by 12
This will really help my spreadsheet.
Thanks for the quick and accurate reply. -- Thanks, Guy "daddylonglegs" wrote: You could use Analysis ToolPak add-in function MROUND to round to the nearest 12, e.g. =MROUND(A1,12) A1 can be a cell value or replace with another formula. Note: if you mean round the nearest 12% then change to =MROUND(A1,0.12) Without Analysis ToolPak =ROUND(A1/12,0)*12 Again, for rounding to the nearest 12% change to =ROUND(A1/12%,0)*12% "Guy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
![Guy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
