# IF statement

#### TracyinNOLA

##### New Member
Hi, I'm having a challenge creating an IF statement that responds the way I would like.

I've worked out the first part, it looks like this:
=IF(OR(B3="Vacant Lot", B3="Slab/Flatworks"), "Declined", " ")

In that same statement I want to add another option, but here I run into problems.

1. If L3 has a date in it (eg: 3/3/2010) then M3="Evaluated". The problem is that I will be using this formula in multiple rows with different dates.

2. I want to combine the first IF statement with this one:
=IF(L3=(has a date in it), "Evaluated", " ")

3. Rather than have a blank in it, if L3 has a date in it I want M3 to read "Evaluated", not "Declined" or " ".

Any suggestions would be greatly appreciated.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### AlphaFrog

##### MrExcel MVP
This doesn't check if L3 has a "date" but rather it checks if L3 is empty or not. Does that work for you?

Code:
``=IF(NOT(ISBLANK(L3)),"Evaluated", IF(OR(B3="Vacant Lot", B3="Slab/Flatworks"), "Declined", " "))``

#### ilak1008

##### New Member
Hi, I'm having a challenge creating an IF statement that responds the way I would like.

I've worked out the first part, it looks like this:
=IF(OR(B3="Vacant Lot", B3="Slab/Flatworks"), "Declined", " ")

In that same statement I want to add another option, but here I run into problems.

1. If L3 has a date in it (eg: 3/3/2010) then M3="Evaluated". The problem is that I will be using this formula in multiple rows with different dates.

2. I want to combine the first IF statement with this one:
=IF(L3=(has a date in it), "Evaluated", " ")

3. Rather than have a blank in it, if L3 has a date in it I want M3 to read "Evaluated", not "Declined" or " ".

Any suggestions would be greatly appreciated.
Hi TracyinNOLA

Try this:

=if(L3<>"","EVALUATED","")

#### TracyinNOLA

##### New Member
It works! Perfectly. Thank you so much.

1,106,712
Messages
5,512,994
Members
408,928
Latest member
Black Vinyl