Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron Green
 
Posts: n/a
Default 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   Report Post  
David Billigmeier
 
Posts: n/a
Default

=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   Report Post  
David Billigmeier
 
Posts: n/a
Default

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


  #5   Report Post  
KL
 
Posts: n/a
Default

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   Report Post  
KL
 
Posts: n/a
Default

....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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
writing a formula for a colored value aaronwexler New Users to Excel 11 September 1st 05 03:11 PM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus Excel Worksheet Functions 12 January 23rd 05 05:52 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"