Show denominator and numerator of fraction - Page 2
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Show denominator and numerator of fraction

  1. #11
    New Member
    Join Date
    Jan 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show denominator and numerator of fraction

     
    Hello,

    I have a value like 18 25/374, an I am getting the numerator vale correctly as 6757, but get a #value! for the denominator.
    Using the formula posted as:
    =LEFT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0 ==> FOR Numerator
    =RIGHT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0 ==> For denominator

    Please help. Thanks,

  2. #12
    Board Regular XLXRider's Avatar
    Join Date
    Jul 2004
    Posts
    180
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show denominator and numerator of fraction

    Brilliant. Works for me. Thanks!

    Quote Originally Posted by IML View Post
    There may be a better way, but
    num
    =LEFT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0

    denom
    =RIGHT(TEXT(A1,"???/???"),FIND("/",TEXT(A1,"???/???"))-1)+0
    "When you build an idiot-proof Worksheet, they'll build a better idiot."

  3. #13
    New Member
    Join Date
    Feb 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Show denominator and numerator of fraction

      
    Hello.... this is how it worked for me when the formula included the equal "=" sign...

    =RIGHT(LEFT(FORMULATEXT(A1),FIND("/",FORMULATEXT(A1),1)-1),LEN(FORMULATEXT(A1))-LEN(LEFT(FORMULATEXT(A1),FIND("/",FORMULATEXT(A1),1)-1))+1)
    =RIGHT(FORMULATEXT(A1),LEN(FORMULATEXT(A1))-FIND("/",FORMULATEXT(A1),1))

    Took me a while to make this work... The thread above does not work for me... could be caused by the difference in Excel version? Anyway, thanks everyone for the tips..

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com