I have to create a spreadsheet that determine the number of parts that need checked and that number varies depending on the bin quantity which is determined by referencing a table.
ex. if a bin of product has 1-15 parts in it; 2 of them must be checked. If the bin contains 16-25 parts, then 3 must be checked, etc etc.
So if I input a bin quantity of 20, I would want excel to figure out that 3 parts need to be checked out of that bin.
I'm guessing that I would need to create a reference table of some kind, but I really don't know the best way to go about this. If someone could point me in the right direction or a tutorial I would greatly appreciate.
Thanks in advance
Bookmarks