I am trying to set up a formula to return the text Yes if two conditions are met and No if they are not.
Column H contains a value between 1 to 25
Column P contains text of either "Open" or "Closed"
The formula should return "YES" if the value in H is greater than or equal to 12 and column P has the text "Open"
If column P has the text "Closed" then the formula needs to return "No"
I have used this site for years as it's a valuable resource but have always found the answers I need via other posts. Any help would be greatly appreciated!