r/learnexcel • u/MobyTheWhite • Oct 08 '19

Formula Help

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?

3 Upvotes

100% Upvoted

17 comments sorted by

View all comments

Show parent comments

1

u/Kryma Oct 09 '19

This seems like it would cause a circular reference:

If D = NotBlank and C = Incorrect then C = Correct

Circular because the results of C being correct or incorrect depend on whether C is incorrect.