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

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

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