Formula Possibilities

Copper Contributor

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.

1 Reply

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.