SOLVED

Excel Formula Help IF AND STATEMENT

Copper Contributor

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. 

3 Replies
best response confirmed by BraytonM (Copper Contributor)
Solution

@BraytonM 

In C2:

 

=IF(B2>=IF(A2="OH",10,20),"KEEP","DELETE")

 

Fill down/

Thank you so much. This worked out great.
Funny enough, I came up with
=IF(OR(AND(A2="OH",B2>=10),AND(A2<>"OH",B2>=20)),"Keep","Delete") moments after you sent this. Thank you, this stumped me yesterday.
1 best response

Accepted Solutions
best response confirmed by BraytonM (Copper Contributor)
Solution

@BraytonM 

In C2:

 

=IF(B2>=IF(A2="OH",10,20),"KEEP","DELETE")

 

Fill down/

View solution in original post