How to I combine two IF(AND formulas to get desired results

[ArcticAce]

Sorry, I am sleepy: How do I combine two IF(AND formulas to get a desired result or leave blank if both formulas are FALSE


The formula in B1 is =IF(AND($A1>=$E$1,$A1>=$F1),$F$2,"")

The formula in C1 is =IF(AND($B1>=$E$2,$B1>=$F2),$F$3,"")

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

Can anyone help me with this issue, and I have tried my best to explain it.​

[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]

10/1/2017​

<strike></strike>[/TD]
[TD]<strike></strike>11/30/2017[/TD]
[TD]12/31/2017[/TD]
[TD][/TD]
[TD]10/1/2017[/TD]
[TD]10/31/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11/2/2017[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[TD][/TD]
[TD]11/1/2017[/TD]
[TD]11/30/2017[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]12/13/2017[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[TD][/TD]
[TD]12/1/2017[/TD]
[TD]12/31/2017[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1/6/2018[/TD]
[TD][/TD]
[TD]FALSE[/TD]
[TD][/TD]
[TD]1/1/2018[/TD]
[TD]1/31/2017[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]

10/1/2017​

<strike></strike>[/TD]
[TD]

11/30/2017​

[/TD]
[TD]

12/31/2017​

<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]

11/2/2017​

<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]

12/13/2017​

<strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]

1/6/2018​

<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

but leave blank any dates in Column A that are after 1/1/2018 and so on.

how are col A cells checked

The formula in C1 is =if(iserror(IF(AND($B1>=$E$2,$B1>=$F2),$F$3,"")),dothis,dothat))

check how many brackets you need

 

[ArcticAce]

Can you give me more details about the portions you want me to try?

 

[oldbrewer]

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

I do not understand what you mean above eg leave blank any dates - how are you changing cells in column A ?

 

[ArcticAce]

I need a formula that can be combined with the formula in C1 to give me the result of C12, if C1 is FALSE, but leave blank any dates in Column A that are after 1/1/2018 and so on.

I do not understand what you mean above eg leave blank any dates - how are you changing cells in column A ?

The dates in column a are entered when a discussion with an employee is conducted. The other columns are for automation to show when the next discussion is due. So the columns after A will show all discussions for the year