LF MS Excel Wizard: Halp

Ok, as it says, looking for some help regarding MS EXCEL.

trying to make a spreadsheet, where I can edit a cell, input a number, as say 45.207 and have it rounded up to the nearest... fraction.
but not just any fraction, want to use
?/16, ?/8, ?/4, ?/2, ?

while I can edit the cells to do one fraction, I can't make it use different fractions, and all will only show up in one way.


why am I using Excel?
making a Cutting list, 10 sets, of 70+ pieces each, and manually rounding up and converting each measurement is slow-ish lol.

avail tools:
MS Office 365
MS Office Online
Google Docs
MS Access

Halp plx? :D

right click the cells you're inputting data to->
format cells ->
fractions ->
choose fraction levels


Sound like you want 'up to one digit' or 'up to two digits'.

yeah I got that far, but the lowest I am allowed to go is to a sixteenth

#/16
the problem is tho, If i where to input 42.512, it will appear as 42 8/16 instead of 42 1/2

using the two digit option, I will end up with funky measurements. fractions
:/

You could manually create a custom field specifying the fraction requirement for all of them to be out of 16 too, like such:

Oh oh, then copy/paste the entire column to a notepad. Then paste it back into excel. Aftewards format again with fractions 'up to two digits'.

Okay that worked for my set of dummy data I made up. It took a tiny bit of tinkering.

1) Use the custom format filter to specify fractions of # ??/16
2) Copy/paste all of your data to an outside program, notepad
3) Replace all double spaces in the notepad with a single space
~ a) CTRL+H
~ b) Two blank spaces in find what
~ c) one blank space in replace with
~ d) replace all
4) Copy/paste all data from notepad back to excel
5) Format as fractions up to two digits, should appear good!

hmm didnt think of that
convert and round up to fraction and then auto adjust to the right fraction.

\('-')/ should be faster than manually doing it

Place the measurement data you want to round in column A.

In column D create a list of fractions you want to round to. e.g. 1/2, 1/3, 1/4, 1/5.

Select cell F2. Goto Data > Data Validation. Select "List" from the drop down and source the range of cells containing the list of fractions you just created in column D. Cell F2 now determines what fraction you want to round your dress sizes to.

In column B, alongside column A with your measurement data in, type:
=CEILING.PRECISE(A1,$F$2)
Drag this formula down.

Format column B to fraction.

Use the drop down in cell F2 to decide what fraction you want to have your measurement sizes round up to.

Edit: If you have trouble send me your email in PM and i'll forward you a spreadsheet. Won't take 2 secs.

Don't use goddamn imperial units.

I'd probably do something like
, if you know that they all correspond to given values.
Otherwise, i'd replace the LOOKUP with

Can't say that would work, since I'm not sitting with excel at the moment, but that'll probably get in the ballpark.

way i set it up, and works ok-ish

(Piece number) (measurement) (<-previous cell, fraction set to #/16) (<- row copy pasted into a text doc and copy pasted back. set to fraction)
hide input and conversion row, print

:D