Consulting

Results 1 to 8 of 8

Thread: Issue with Excel Division of Fractions..Not showing correct results

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Issue with Excel Division of Fractions..Not showing correct results

    Here is what I did..

    Generated Random Fractions in Cell B and C and added the result in Cell D. I want it to give me traditional Fraction addition, like we do in school. But its giving weird results.

    It is showing 26/29 + 0 = 68/75 !!!!!! Refer attached picture. It shall give me 26/29. (Sample Row 10)
    It is showing 2/11 + 3/7 = 11/18 !!!!! Refer attached picture. It shall give me 47/77. (Sample Row 12)

    Please let me how do i achieve traditional Fraction addition , subtraction , multiplication, division in Fractions ???
    Attached Images Attached Images
    Attached Files Attached Files

Posting Permissions

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