Help with Nested IF Formula Needed

Hi there,

I have an Excel spreadsheet in which I'm trying to add a column that will populate one of four values based on data elsewhere in the sheet. Here's a list of the values I would need to populate and data elsewhere in the sheet that would need to be present in order for each value to appear:

(1) Official Launch: Cell A1 is blank and the string of text in Cell B1 contains the phrase "sec.gov"

(2) Launch: Cell A1 is blank and the string of text in Cell B1 does not contain the phrase "sec.gov"

(3) Official Close: Cell A1 has a value, and the text in Cell B1 contains the phrase "sec.gov"

(4) Close: Cell A1 has a value, and the text in Cell B1 does not contain the phrase "sec.gov"


I can attach an example sheet with some of the values in columns A and B in my sheet if this would be helpful.

Any idea on how to do this or if it's even possible?

I'm not seeing an attachment to that first reply if there is one. Am I missing something?

For the second solution, testing that formula and it seems to be getting me partway there, but it isn't outputting all of the four items I'm looking for.

Popipipo - the first formula in that spreadsheet you attached works perfectly! Thanks for the help!