Results 1 to 9 of 9

Thread: Dividing fractions into new cell

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Dividing fractions into new cell

    I am looking for a way to divide a fraction in one cell and put the percentage of that fraction into the next cell.

    Example: B2- 36/164 C2- Percentage from B2 (36/164 = 21.95%)

    Any help is greatly appreciated. Thanks.

  2. #2
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    648
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Dividing fractions into new cell

    Hey,

    B2: =36/164
    C2: =B2

    Then format C2 as a percentage with 2 decimals

    Is this what you are after?
    √-1 2³ ∑ π
    …And it was delicious!

  3. #3
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,680
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Dividing fractions into new cell

    If it's text you could try:

    =LOOKUP(10^9,--LEFT(A1,{1;2;3;4;5;6;7;8;9}))/LOOKUP(10^9,--RIGHT(A1,{1;2;3;4;5;6;7;8;9}))
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!

  4. #4
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,699
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Dividing fractions into new cell

    Hi

    What do you have in A2

    The formula: =36/164 that displays the number 0.2195...

    or

    The text value: 36/164

    ?
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,280
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Dividing fractions into new cell

    Another way:


     ABC
    1   
    2 36/1640.2195122

    CellFormula
    C2=--LEFT(B2,FIND("/",B2)-1)/--MID(B2,FIND("/",B2)+1,16)
    Last edited by DanteAmor; Jul 26th, 2019 at 10:21 AM.
    Regards Dante Amor

  6. #6
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,699
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Dividing fractions into new cell

    For a text value I'd use:

    =("0 "&A1)+0
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  7. #7
    New Member
    Join Date
    Jul 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dividing fractions into new cell

    I have text in B2. DanteAmor, your formula worked perfect! Thank you all for your help!

  8. #8
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,269
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Dividing fractions into new cell

    Quote Originally Posted by pgc01 View Post
    For a text value I'd use:

    =("0 "&A1)+0
    Nice

    M.

  9. #9
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,280
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Dividing fractions into new cell

    Quote Originally Posted by dsacomano View Post
    I have text in B2. DanteAmor, your formula worked perfect! Thank you all for your help!
    You're welcome, thanks for the feedback.
    But, the pgc01 formula is better.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •