I wa wondering if there was a way to simplify fractions down to fractions the can be found on a standard ruler.
My data in call A1 Desired Results
8 8/16 8 1/2
4 4/16 4 1/4
2 13/16 2 13/16
2 2/16 2 1/8
1 11/16 1 11/16
1 7/16 etc....
1 3/16
1 1/16
15/16
14/16
Basically I'm turning decimals into fractions over 16 and then i want them simplified.
Thanks in advance for any insight
LOS
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
here is a sample i thought it would keep the formatting....
B2: =MROUND(B$1/$A2, 1/16) Format of B2: # ??/16
Last edited by shg; 01-25-2018 at 12:59 PM.
Entia non sunt multiplicanda sine necessitate
In E2, copied down:
=MROUND(D2,1/16)
Format cells as: # ??/??
See sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the tips!!!!
worked like a charm....
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks