Formula for rounding to the nearst eighth of one percent

G

Guest

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%.
 
G

Guest

=MROUND(7.4,1/8)

First have to install the Analysis ToolPak, though, Tools->Add-Ins->Check
Analysis ToolPak
 
G

Guest

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.
 
K

KL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to the Nearest Eighth 4
A rounding function 4
Rounding Interest to nearest eighth 6
Formula help - rounding up and round down? 2
Finding dynamic maxima 8
Round Function 5
Round to the nearest minute if more than 6 seconds 2
correct syntax for nesting "if", "and", and "vlookup"....if possib 4

Top