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%.
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 [email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote in message
> news:[email protected]...
>>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%.
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks