IF, IFS, nested IF, right formula?

[shakethingsup]

Hi everyone, okay I'm stumped and I'm getting lost in "IF" statements. I feel like I'm making things so complicated. Let me try and explain.

This excel file lists units in an apartment building. I need to indicate if the unit is VACANT or AVAILABLE.

	A	B	C	D	E	F
1			Today's date	June 7, 2017
2
3			Date Available for Rent	Occupancy Date	Application Approval Date	OUTPUT
4		exampl 1
5		exampl 2	May 1, 2017			V
6		exampl 3	July 1, 2017			A
7		exampl 4	June 1, 2017	July 1, 2017
8		exampl 5	June 1, 2017	July 1, 2017	June 20, 2017

<tbody>
</tbody>

Above is the example:
1. Output is where the formula will be. The only outputs are " ", "V", "A"
2. I want to drag the formula down all rows
2. exampl 1 - There are gaps in the spreadsheet - the output for gaps should be " "
3. exampl 2 - If today's date > date available - output = V
4. exampl 3 - If today's date < date available - output = A
5. exampl 4 - If date available is not blank and occupancy is not blank - out = " "
6. exampl 5 - If all 3 cells is not blank out put should be " " - same as exampl 1


What I tried:
1. I first tried nested IF statements, then started to lose track
2. Then I looked towards IFS statements, googled how best to achieve this but most of the examples I found were only considering one cell. For example determining someones grade based on their score.


Any help?

 

[Tetra201]

See if this works for you:

=IF(COUNT(C4)-COUNT(D4:E4)=1,IF(C4>TODAY(),"A","V"),"")

 

[shakethingsup]

See if this works for you:

=IF(COUNT(C4)-COUNT(D4:E4)=1,IF(C4>TODAY(),"A","V"),"")

You're brilliant. It looks like this worked.