# IF/AND FORMULA?

#### chef

##### Well-known Member
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

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### arthurbr

##### Well-known Member
Perhaps
Excel Formula:
`` =IF(and(B7<>"",I7<>""),"Closed",IF(B7<>"","Open",""))``

#### jtakw

##### Well-known Member
Hi,

Try this:

Book3.xlsx
BCDEFGHIJ
72/28/20213/1/2021Closed
83/1/2021Open
93/2/2021
Sheet814
Cell Formulas
RangeFormula
J7:J9J7=IF(B7="","",IF(I7="","Open","Closed"))

#### chef

##### Well-known Member
Thank you both so much for taking the time to reply.

I now have this working perfect and really grateful
regards

#### jtakw

##### Well-known Member
You're welcome, thanks for the feedback.

Replies
28
Views
604
Replies
7
Views
443
Replies
3
Views
93
Replies
1
Views
169
Replies
7
Views
40

1,129,441
Messages
5,636,305
Members
416,912
Latest member
danluk12

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back