Apr 23 2021 07:14 AM
Hello, I in need of assistance creating a single statement reflecting two columns: WorkType and Hours.
If WorkType = "OH" and Hours >=10, "KEEP", "DELETE"
If WorkType<> "OH" and Hours >=20, "KEEP", "DELETE"
For whatever reason, I cannot make a single statement that fits both criterion that works for my worksheet. I have attached it below.
Apr 23 2021 07:30 AM
SolutionApr 23 2021 07:34 AM
Apr 23 2021 07:37 AM
Apr 23 2021 07:30 AM
SolutionIn C2:
=IF(B2>=IF(A2="OH",10,20),"KEEP","DELETE")
Fill down/