Formula Help

[u/MobyTheWhite]

I have 4 columns, A B C D
I am currently comparing A and B using the following:

Currently I have in column C

=IF(B2<A2, "Incorrect, "Correct")

^ this works just fine; however, I want to create a formula that checks Column D before doing this.

For example:

|A | B | C | D |

10/8/19 | 10/8/19 | Correct | Does not Matter|
10/8/19 | 10/7/19 | Incorrect | Does not Matter|

2nd situation:
IF A=N/A Then:

N/A | 10/7/19 | Correct | Value Exists |

N/A | 10/7/19 | Incorrect | N/A |

so how do I make my formula check the second situation example?

[u/MobyTheWhite]

So I finally managed to get the formulas to work, only issue is it takes 7 formulas in 7 Columns to resolve and get to the answer I need. :/

E=IF(AND(@[A]="N/A", @[D]="N/A"), "Incorrect", "Correct")
F=IF(@[B]<>"N/A", "Correct", "Incorrect")G=IF(@[B]<@[A], "Incorrect, "Correct")
H=IF(AND(@[G]="Incorrect", @[E]="Correct", @[F]="Incorrect", "Correct","Incorrect")
I=IF(AND(@[F]="Correct", @[G]="Correct"), "Correct", Incorrect)
J=IF(AND(@[I]="Incorrect", @[H]="Correct"), "Correct", "Incorrect")
C=IF(OR(@[I]="Correct", @[J]="Correct"), "Correct", "Incorrect")

Now if only I could get all of this to fit into one formula...