Formula for rounding to the nearst eighth of one percent
 

I would like to create a formula that rounds the sum of two cells to the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.

=MROUND(7.4,1/8)

First have to install the Analysis ToolPak, though, Tools-Add-Ins-Check
Analysis ToolPak
--
Regards,
Dave


"Ron Green" wrote:

I would like to create a formula that rounds the sum of two cells to the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.

Come to think of it I don't know if you need to install the Analysis ToolPak,
it might be just an included function. But if you try it and it doesn't work
then you gotta install it.
--
Regards,
Dave


"David Billigmeier" wrote:

=MROUND(7.4,1/8)

First have to install the Analysis ToolPak, though, Tools-Add-Ins-Check
Analysis ToolPak
--
Regards,
Dave


"Ron Green" wrote:

I would like to create a formula that rounds the sum of two cells to the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.

How about:

=ROUND(A3/0.00125,0)*0.00125

=ROUND(A3/(0.01/8),0)*(0.01/8)

No need to install anything.

Regards,
KL


"Ron Green" <Ron wrote in message
...
I would like to create a formula that rounds the sum of two cells to the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.

It is an Analysis ToolPak function.

Regards,
KL


"David Billigmeier" wrote in
message ...
Come to think of it I don't know if you need to install the Analysis
ToolPak,
it might be just an included function. But if you try it and it doesn't
work
then you gotta install it.
--
Regards,
Dave


"David Billigmeier" wrote:

=MROUND(7.4,1/8)

First have to install the Analysis ToolPak, though, Tools-Add-Ins-Check
Analysis ToolPak
--
Regards,
Dave


"Ron Green" wrote:

I would like to create a formula that rounds the sum of two cells to
the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell
2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.

....A3 = 7.4%

KL


"KL" wrote in message
...
How about:

=ROUND(A3/0.00125,0)*0.00125

=ROUND(A3/(0.01/8),0)*(0.01/8)

No need to install anything.

Regards,
KL


"Ron Green" <Ron wrote in message
...
I would like to create a formula that rounds the sum of two cells to the
nearest eighth of one percent. Specifically, Cell 1, 5.00%, plus Cell 2,
2.40%. The sum is 7.40%, but rounded to the nearest eighth it would be
7.375%.