Sep 13 2021 04:35 AM
I need to convert the following data in a formula.
number packages | full packages | damaged packages | number shops | formula |
100 | 80 | 20 | 50 | I must assign the full packages according to 40% and damaged on a 30% basis. |
Sep 13 2021 04:48 AM - edited Sep 13 2021 06:21 AM
If(OR(FullPackges/NumberPackages)>0.4,(DamagePackages/NumberPackages)>0.3),"Assign","Nothing")
=IF(OR((B2/A2)>=0.4,(C2/A2)>0.3),"Assign","Nothing")