IF/AND FORMULA?

[chef]

I have a brain freeze and would welcome a little help please.

Cell B7 can either have a date or be blank
Cell I7 can either have a date or be blank
Cell J7 - I'm Trying to show either Open or Closed or ""

I am trying to get a formula in J7 that shows "Open" if B7 has a date or leave blank/ "" if no date but "Closed" if both B7 and I7 also has a date

ive played around with if(and and not getting right and latest nested is not coming up with right result

=IF(B7<>"",IF(I7<>"","OPEN","CLOSED""),"")

probably simple but i'm going round in circles and would appreciate a nudge as to where I am going wrong

regards

 

[arthurbr]

Perhaps

 =IF(and(B7<>"",I7<>""),"Closed",IF(B7<>"","Open",""))

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	B	C	D	E	F	G	H	I	J
7	2/28/2021							3/1/2021	Closed
8	3/1/2021								Open
9								3/2/2021
Sheet814

Cell Formulas
Range	Formula
J7:J9	J7	=IF(B7="","",IF(I7="","Open","Closed"))

 

[chef]

Thank you both so much for taking the time to reply.

I now have this working perfect and really grateful
regards

 

[jtakw]

You're welcome, thanks for the feedback.