Sep 21 2019 08:07 AM
New here and hoping someone can help. I am trying to create a database of parts and wanted to make a formula to calculate complete sets for a project based on the different parts available. Is there a way to make a formula that will just add 1 to the total sets box for every increment of the specific parts being available. For example, if i need four wheels, one chassis, one computer, and 2 frames for a project, can i make a box add 1 for every full set. Like if i input that i have 15 wheels, 5 chassis, 2 computers, and 7 frames, can i get the box to return a 2 but go up to a 3 if i add a computer but not a four unless i add a frame and a wheel? Thx for any help in advance.
Sep 24 2019 02:59 PM
Hello @ExcelAmateur ,
yes, something like that can be done in Excel. It will probably require programming with VBA. You may find some approaches if you google for inventory management with Excel.