TracyinNOLA
New Member
- Joined
- Aug 2, 2010
- Messages
- 3
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.
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.