excel formula

Copper Contributor

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")