I would like to have fractions only shown in increments of 1/16. I don't want to see 1/5, 1/10, 1/12, 1/25, etc.
Only want to see 1/16, 1/8, 3/16, 1/4, 5/16, 3/8, etc.
Fractions round up to the nearest 1/16.
Is this possible?
I'm wanting to give plant operators access to a spreadsheet which they can input a number and receive an output in a format they can equate to a distance on their tape measure.
Thanks
• Select your range of values
• Home.Format.Format_Cells.Number_Tab...(or use the shortcut: CTRL+1)
...Category: Fraction
...Type: As sixteenths (8/16)
...Click: OK
Does that help?
I've tried that but the problem with this format is that 16ths are forced rather than showing 8/16 as 1/2.
It's fine for me but the guys that will be using it may be left scratching their head at fractions like 6/16.
Perhaps this will work:
This formula rounds the referenced cell UP by sixteenths:
• B1: =CEILING(A1,1/16)
• Format that cell to reflect fractons (Category: Fractions, Type: Up to two digits)
• Copy B1 and paste down as far as you need.
Thanks.
Can you tell me how to incorperate that into D4: =(C4*A4) & D5: =(C5*A4), etc.?
C4 being a percentage and A4 being the user entered value.
I don't have a lot of excel or programing experience as I'm sure you can tell.
Thanks again.
Sure...Try this:
Copy that formula down as far as you need.
D4: =CEILING(C4*A4,1/16)
This changed a value from 8/16 to 9/16 rather than 1/2.
You did mention that you want the values rounded UP by sixteenths, right?Originally Posted by 70bird
Can you give an example...including values...so we can see if there's an issue?
I think I figured out the problem just before I hit reply. Changed the format to 2 digit and your above suggestion worked.
Here's what I was getting ready to post which turned on the light bulb.
No problem.
Since the cell is aready formatted to 1/16 all values are automatically rounded to the nearest 16th. I just want the value to show the simplified fraction rather than every fraction shown as a 16th.
Example:
F14: Cell format - Up to two digits (21/25) - Value displayed: 46 6/17
F14: Cell format - As sixteenths (8/16) - Value displayed: 46 6/16 (this has already been rounded to nearest 16th)
F14: Desired value displayed: 46 3/8
Thanks again.
I spoke too soon.
Example:
D14: =(C14*A4): Format 2 places - Output: 7 8/61
D14: =(C14*A4): Format 16th - Output: 7 2/16
D14: =ceiling(C14*A4,1/16): Format 16th - Output 7 3/16 (Expected 7 1/8)
D14: =ceiling(C14*A4,1/16): Format 2 digits - Output 7 3/16 (Expected 7 1/8)
The desire is to round to the nearest 16th rather than always up.
OK...now I understand.
Try this:
Does that help?D4: =MROUND(C4*A4,1/16)
That is exatly what I needed.
Thanks!
Formatted to 2 digits and works perfect.
Thanks again.
Maybe you could help me with this one too:
http://www.excelforum.com/excel-2007...-question.html
iv had the same problem... but I dont want it to round up to the nearest 16th...
ie... the true value I desire is 5/16... but it always round up to 3/8!
GCSlapper,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks