IF/THEN

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3173591%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EIF%2FTHEN%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3173591%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20Everyone%2C%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%26nbsp%3B%20IF%20formula%20but%20I%20am%20having%20trouble.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EEssentially%20I%20am%20trying%20to%20tell%20clients%20that%20IF%20they%20have%20X%20amount%20of%20a%20product%20we%20can%20make%20Y%20amount%20of%20products%20out%20of%20it%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESo%20for%20example%20recycling%203%20mannequins%20we%20can%20make%201%20panel%20and%20so%20on%20so%206%20%3D%202%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECould%20anyone%20provide%20the%20formula%20do%20to%20this%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3173591%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi Everyone, 

 

I am trying to create a  IF formula but I am having trouble. 

 

Essentially I am trying to tell clients that IF they have X amount of a product we can make Y amount of products out of it 

 

So for example recycling 3 mannequins we can make 1 panel and so on so 6 = 2 

 

Could anyone provide the formula do to this?

1 Reply

@jasmineb340 

Mannequins_vs_panels.jpg

if I understood it correctly...here is a suggested solution.

 

Hope I could help you with these information.

 

NikolinoDE

I know I don't know anything (Socrates)