Multiple Yes/No formulas

[sapper]

	A	B	C	D	E	F
1	Initially Approval	Issued	Projected Begin Date	Projected End Date	Final Approval	Today's Date
2						23 Jul 18
3	Yes	No	22 Jun 18	10 Nov 18	Yes
4	Yes	Yes	25 Aug 18	10 Nov 18	Yes
5	No	Yes	18 Jul 18	10 Nov 18	No
6	No	No	2 Jul 18	10 Nov 18	No

<tbody>
</tbody>

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.