Multiple Yes/No formulas

[sapper]

[TABLE="class: grid, width: 500, align: center"]
<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]Initially Approval
[/TD]
[TD]Issued
[/TD]
[TD]Projected Begin Date
[/TD]
[TD]Projected End Date
[/TD]
[TD]Final Approval
[/TD]
[TD]Today's Date
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23 Jul 18
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Yes
[/TD]
[TD]No
[/TD]
[TD]22 Jun 18
[/TD]
[TD]10 Nov 18
[/TD]
[TD]Yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Yes
[/TD]
[TD]Yes
[/TD]
[TD]25 Aug 18
[/TD]
[TD]10 Nov 18
[/TD]
[TD]Yes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]No
[/TD]
[TD]Yes
[/TD]
[TD]18 Jul 18
[/TD]
[TD]10 Nov 18
[/TD]
[TD]No
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]No
[/TD]
[TD]No
[/TD]
[TD]2 Jul 18
[/TD]
[TD]10 Nov 18
[/TD]
[TD]No
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am trying to determine the correct formula if a column has a "NO" input then another column will also have a "NO" input along with another embedded formula.

The formula I have alreadyhave for cell E6 is: =IF(C6<=$F$2>D6,IF(B6="YES","NO","YES"),IF(B6="NO","YES","NO"))


Any help would be appreciated.

 

[Aladin Akyurek]

Try to post the values you want to seen E instead of what your formula delivers.

 

[sapper]

If the value in cell A6 = “NO”, then cell E6 = “NO”. Nofurther actions permitted.
If the value in cell A6 = “YES”, then cell E6 shoulddetermine if the ‘Projected Begin Date’ is before ‘Today’s Date’ and before ‘ProjectedEnd Date’, if that is correct, then if column B is “NO”, column E is “YES”.
I hope this is what was requested.