Posts by MantaLady
-
-
Re: Return "YES" if cell H2 >12 and cell P2=Open - If no match return "NO"
Fantastic! Thanks a million.
As ever with formula's once you have something that works you realise you didn't think all the variables through and ask the right question in full! I have pasted that formula down the relevant column and it works great however is there a way to also include in the formula if cell P2 is blank to leave the cell blank? Sorry to be such a pain.
-
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!