See attached. The user selects the alloy and enters the stock diameter. The formula for the RPM then is (I think):



=IFERROR(12*VLOOKUP(A2,MaterialSFPM,2,FALSE)/(PI()*C2),"")

Since the vlookup to find the SFPM is included in the formula, the SFPM column is superfluous and can be deleted.

For 1/4" stock brass, the formula returns 2292. If this is overly precise and you would like it rounded to the closest hundred (included as RPM rounded):

=IFERROR(ROUNDUP(12*VLOOKUP(A2,MaterialSFPM,2,FALS E)/(PI()*C2),-2),"")

For the closest, ten, change that -2 near the end to -1. Easy peasy. :-) It would probably be a good idea, once you have it all fleshed out, to lock any formula cells and protect the sheet. If you need any further help with that or anything else, let me know.

Attached Files

MaterialSFPM.xlsx (13.2 KB, 11 views)

By jove, I think you've got it! You seem to have used a formula that I've never tried...the "IFERROR" formula. I think I can take that and run with it, but I might be back soon with another question or two.

Thank you!