IF statement

[TracyinNOLA]

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.

 

[AlphaFrog]

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

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

 

[ilak1008]

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]

It works! Perfectly. Thank you so much.