Adding the word "Not Applicable" to an If, and then formula

[searchingforhelp]

Hello,

Seeking help in updating a formula in column E to include the word "not applicable" when it applies to scenarios that are in row 3 and 6. The rest of the formula would need to work as is, to identify the "Within Policy" “Out of Policy” for the original assigned.

Example 4-27-2021.xlsx
	A	B	C	D	E	F
1	Date Original Assigned	Reassigned Date	Owner Review Date	Original assigned	Number of Business Days for the Original assigned	Days the Origional assigned is
2	1/1/2021		1/4/2021	Within Policy	2	2
3	1/1/2021	1/4/2021	1/6/2021	Within Policy	2	2
4	1/4/2021		1/11/2021	Out of Policy	6	-2
5	1/6/2021	1/14/2021	1/14/2021	Out of Policy	7	-3
6	1/9/2021	1/14/2021	1/14/2021	Within Policy	4	0
7	3/10/2021	3/16/2021	3/22/2021	Out of Policy	5	-1
8	3/11/2021	3/17/2021	3/15/2021	Within Policy	3	1
Example (2)

Cell Formulas
Range	Formula
D2:D8	D2	=IF(ISNUMBER(F2),IF(F2>=0,"Within Policy","Out of Policy"),F2)
E2:E8	E2	=IF(AND(B2<C2,B2<>""),NETWORKDAYS(A2,B2),NETWORKDAYS(A2,C2))
F2:F8	F2	=IF(ISNUMBER(E2),-(E2-4),E2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D12,D16:D1048576,A13:A15	Cell Value	="Out of Policy"	text	NO
D2:D12,D16:D1048576,A13:A15	Cell Value	="Within Policy"	text	NO

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Alex Blakenburg]

Thank you for letting us know. Glad we could help.