+ Reply to Thread
Results 1 to 3 of 3

Reducing fractions

  1. 10-10-2014, 04:37 PM #1
    blackshag
    blackshag is offline
    Registered User
    Join Date
    11-02-2012
    Location
    WA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Reducing fractions

    I am entering a length of an item into Cell O21 as a decimal number.

    O21 is currently set to display fractions as ??/32 so it takes that decimal number and rounds to the nearest /32. This is fine because numbers like .78 will reduce round to 25/32 rather than display as 39/50. I don't want the numbers to display in further detail than /32.

    I would like O21 to display fractions in their most reduced form, but never display any further in detail than /32.

    Example:

    If length of item is 6.888, O21 currently displays that as 6 22/32.

    How can I get it so that O21 displays that fraction as 6 11/16?

    Thank you
    Reply With QuoteRegister To Reply
  2. 10-10-2014, 04:49 PM #2
    ben_hensel
    ben_hensel is offline
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Reducing fractions

    The easiest workaround is to use a helper column.

    A1 = value
    B1 =MROUND(A1, 1/32)
    //format B1 as fractions to two decimal places

    That also allows you to put headers over them so that the first column can be "decimal value" and the second can be named "closest 32th".
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
    Reply With QuoteRegister To Reply
  3. 10-10-2014, 05:42 PM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Reducing fractions

    Not sure if you want greater accuracy at the expense of not showing /32nds but with 6.888 in a cell that's formatted as FRACTION
    then you'll see 6 8/9

    8/9 as a decimal is much nearer to 6.888 (i.e. 6.888888888888889) than 11/16 which is only .68875.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiply fractions without reducing the fraction
    By karstens in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-03-2013, 09:16 AM
  2. Reducing 2 spaces, down to 1
    By Tywardreath_NZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2009, 11:28 PM
  3. Converting Decimal Fractions to Fractions of a Specified Number
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 11:09 AM
  4. Fractions in 16ths format - reducing to LCD
    By Derek in forum Excel General
    Replies: 4
    Last Post: 06-17-2005, 08:05 AM
  5. [SOLVED] reducing a fraction
    By GreenMonster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1