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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Today's date[/TD]
[TD]June 7, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Date Available for Rent[/TD]
[TD]Occupancy Date[/TD]
[TD]Application Approval Date[/TD]
[TD]OUTPUT[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]exampl 1 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]exampl 2[/TD]
[TD]May 1, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]exampl 3[/TD]
[TD]July 1, 2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]exampl 4[/TD]
[TD]June 1, 2017[/TD]
[TD]July 1, 2017[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]exampl 5[/TD]
[TD]June 1, 2017[/TD]
[TD]July 1, 2017[/TD]
[TD]June 20, 2017[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.