Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / April 2005

Tip: Looking for answers? Try searching our database.

How to get Excel to round fractions to nearest 32nd?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
T.R. Young - 27 Apr 2005 14:14 GMT
I have formatted a column to show fractions, but I want that column to
display even denominators, highest of which is 32nds.  Sometimes, I get 5ths,
31s, etc...  Can anyone shed some light on how I can force Excel to round
only to even fractions (quarters, eighths, sixteenths, thirtyseconds) , with
32nds as the lowest denominator?
Thank you for your time!
T.R. Young - 27 Apr 2005 14:30 GMT
Let me clairify; I have a data sheet with cut lengths of multiple objects,
which I enter onto an Excel spreadsheet in a particular column.  I want the
next column to display fractions, rounded to the nearest even denominator,
the lowest of which is 32nds.  It would save me a lot of time to have Excel
convert for me, but I keep getting odd fractions (5ths, 31sts, etc...)
T.R. Young - 27 Apr 2005 14:42 GMT
Ok, if I had been patient and dug a little deeper, I would have found it
before I posted this question.  I found the formula...
Sorry!  :)
JulieD - 27 Apr 2005 15:54 GMT
do share :)

(saves me having to think about it)

Signature

Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway

> Ok, if I had been patient and dug a little deeper, I would have found it
> before I posted this question.  I found the formula...
> Sorry!  :)
zackb - 27 Apr 2005 17:31 GMT
Rounding can be tricky.  There are many formulas to which will do this, and
a lot of them will appear to have the same end result.  Let me assure you
that each rouding-type formula is different, and will have different
outcomes in various circumstances.

That being said, it sounds like you would prefer a CEILING or FLOOR
function, as these will allow you to specify the fraction you wish to go
up/down to (e.g. nearest 1/4 or 1/2 or 1/32, etc).

As I see you have found a solution, I agree with Julie, share please.  :)
Give others the benefit of which you have received.  :)

Signature

Regards,
Zack Barresse, aka firefytr

>I have formatted a column to show fractions, but I want that column to
> display even denominators, highest of which is 32nds.  Sometimes, I get
[quoted text clipped - 4 lines]
> 32nds as the lowest denominator?
> Thank you for your time!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.