Home

Formula Possibilities

%3CLINGO-SUB%20id%3D%22lingo-sub-868741%22%20slang%3D%22en-US%22%3EFormula%20Possibilities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868741%22%20slang%3D%22en-US%22%3E%3CP%3ENew%20here%20and%20hoping%20someone%20can%20help.%20I%20am%20trying%20to%20create%20a%20database%20of%20parts%20and%20wanted%20to%20make%20a%20formula%20to%20calculate%20complete%20sets%20for%20a%20project%20based%20on%20the%20different%20parts%20available.%20Is%20there%20a%20way%20to%20make%20a%20formula%20that%20will%20just%20add%201%20to%20the%20total%20sets%20box%20for%20every%20increment%20of%20the%20specific%20parts%20being%20available.%20For%20example%2C%20if%20i%20need%20four%20wheels%2C%20one%20chassis%2C%20one%20computer%2C%20and%202%20frames%20for%20a%20project%2C%20can%20i%20make%20a%20box%20add%201%20for%20every%20full%20set.%20Like%20if%20i%20input%20that%20i%20have%2015%20wheels%2C%205%20chassis%2C%202%20computers%2C%20and%207%20frames%2C%20can%20i%20get%20the%20box%20to%20return%20a%202%20but%20go%20up%20to%20a%203%20if%20i%20add%20a%20computer%20but%20not%20a%20four%20unless%20i%20add%20a%20frame%20and%20a%20wheel%3F%20Thx%20for%20any%20help%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-868741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873476%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Possibilities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873476%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412959%22%20target%3D%22_blank%22%3E%40ExcelAmateur%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyes%2C%20something%20like%20that%20can%20be%20done%20in%20Excel.%20It%20will%20probably%20require%20programming%20with%20VBA.%26nbsp%3B%20You%20may%20find%20some%20approaches%20if%20you%20google%20for%20inventory%20management%20with%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
ExcelAmateur
Occasional Visitor

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
Highlighted

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.

 

 

 

Related Conversations
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies