Formula for rounding to the nearst eighth of one percent

  • Thread starter Thread starter Guest
  • Start date Start date
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%.
 
=MROUND(7.4,1/8)

First have to install the Analysis ToolPak, though, Tools->Add-Ins->Check
Analysis ToolPak
 
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.
 
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
 
You must log in or register to reply here.

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

A rounding function 4
Alternate Rounding Up & Down of .50 in a column 5
Rounding numbers up or down in same formula 6
Round Function 5
Rounding Time to Nearest 5 Minutes 1
Rounding Interest to nearest eighth 6
Rounding to the Nearest Eighth 4
Finding dynamic maxima 8

Back
Top