Material cut-off list

**igggy** · 07-31-2012, 08:12 AM

Hey everyone,

I have a little experience in excel and I hope I can explain this. I would like to write a formula for a material cut off list that will round up to the nearest increment of the next available stock size. If I have a plate thickness of .420 I want it to pick .5 for the size. The standard sizes are anything under an inch are incremented by an 1/8 (.125) and anything above an 1.00 increments by 1/4 (.250) Any help would be great.
I think as long as I have that formula I think I can do the rest, I hope. LOL
Here is a sample.

material cut-off list sample.JPG

Thanks

**DBY** · 07-31-2012, 09:56 AM

Hello
Sort you Material Stock Size list largest to smallest and apply the following formula:

Please Login or Register  to view this content.

Here cell B3 contains your lookup value.

Hope it does what you're looking for.

DBY

**igggy** · 08-01-2012, 07:13 AM

That was what i had but for some reason when i have the -1 (greater then) it fails. But if i change it to 1 (less then) it will work, but it rounds down. Any idea why?

I have attached my file and have it highlighted in red

Thanks

**DBY** · 08-01-2012, 07:30 AM

Hello
You have to sort the list largest to smallest, as I mentioned, otherwise the -1 doesn't work. See reply attachment. Does this work?

DBY

**igggy** · 08-01-2012, 07:43 AM

Oh geez! I forgot you mentioned that. Looks like it will work let me look at it and i will get back to you.

Thanks Igggy

**igggy** · 08-03-2012, 01:56 PM

Sorry had to work in the shop for awhile, finally have sometime to work on it. Looks like it will work but it looks like it will not update the way i was hoping it would work in the application I have it in. I will keep at it.

DBY you are the GREATEST! Thanks