Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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%. |
#2
|
|||
|
|||
=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%. |
#3
|
|||
|
|||
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%. |
#4
|
|||
|
|||
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%. |
#5
|
|||
|
|||
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%. |
#6
|
|||
|
|||
....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%. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions |