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
 
Back
Top