Hi!

First time poster here. I use Excel version 14 on Microsoft Office Professional 2010.

I'd like the spreadsheet to automatically select an appropriate material blank size based on the maximum diameter inputted by the user. The stock size needs to be a minimum of 0.5mm larger than the max diameter. There is a long list of sizes, but rather unhelpfully they don't go up in equal increments. If you're interested, the sizes are 80 90 100 115 120 130 140 150 160 170 180 200 220 240.

I'm guessing I need to use IF and THEN type of logic, but I don't have experience with using it on Excel (and I have never used macros or visual basic). How should I go about doing this?

The next stage is to select the length. This is a bit more straight forward, but it will still require me to use a command that I don't know the name of.

The blank length is based on the max width of the part. The width needs to be rounded up to the nearest whole millimeter, then 4 mm gets added on. So 12.7 becomes 17, 11.1 becomes 16 and 18.0 becomes 22. How do I go about doing this one?

Many thanks in advance,

Stephen