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

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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies