excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2745502%22%20slang%3D%22en-US%22%3Eexcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2745502%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20convert%20the%20following%20data%20in%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22560%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22112.594px%22%3Enumber%20packages%3C%2FTD%3E%3CTD%20width%3D%2294.5px%22%3Efull%20packages%3C%2FTD%3E%3CTD%20width%3D%22152.812px%22%3Edamaged%26nbsp%3Bpackages%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2298.5156px%22%3Enumber%20shops%3C%2FTD%3E%3CTD%20width%3D%22100.578px%22%3Eformula%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22112.594px%22%3E100%3C%2FTD%3E%3CTD%20width%3D%2294.5px%22%3E80%3C%2FTD%3E%3CTD%20width%3D%22152.812px%22%3E20%3C%2FTD%3E%3CTD%20width%3D%2298.5156px%22%3E50%3C%2FTD%3E%3CTD%20width%3D%22100.578px%22%3EI%20must%20assign%20the%20full%26nbsp%3B%20packages%26nbsp%3B%20according%20to%2040%25%20and%20damaged%20on%20a%2030%25%20basis.%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2745502%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2745531%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2745531%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154277%22%20target%3D%22_blank%22%3E%40Gabriella_Vicari%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf(OR(FullPackges%2FNumberPackages)%26gt%3B0%2C4%3B(DamagePackages%2FNumberPackages)%3B%26gt%3B%2B0%2C3)%3B%22Assign%22%3B%22Nothing%22)%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(OR((B2%2FA2)%26gt%3B%3D0%2C4%2C(C2%2FA2)%26gt%3B0%2C3)%2C%22Assign%22%2C%22Nothing%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to convert the following data in a formula.

 

number packagesfull packagesdamaged packages number shopsformula
100802050I must assign the full  packages  according to 40% and damaged on a 30% basis.
1 Reply

@Gabriella_Vicari 

 

If(OR(FullPackges/NumberPackages)>0.4,(DamagePackages/NumberPackages)>0.3),"Assign","Nothing")

 

 

 

=IF(OR((B2/A2)>=0.4,(C2/A2)>0.3),"Assign","Nothing")