I have an excel worksheet with 3 columns A, B and C.
Columns A and B may or may not contain a value and Column C is populated with an IF statement which evaluates the values in Columns A and B
and then populates C with text based on the results of the IF. A sample worksheet is attached which shows the details.
What I am trying to accomplish is this:
1) If Columns A and B both contain a value and those values are the same, the IF statement should populate Column C with "OK".
2) If Columns A and B both contain a value and those values are the same after the UPPER function is applied to both values, the IF statement should populate Column C with "OK".
3) If Columns A and B both contain a value but those values are not the same, the IF statement should populate Column C with "Review".
The IF statement I am currently using in Column C is working correctly for these 3 scenarios.
=IF(AND(NOT(ISBLANK(A2)),NOT(ISBLANK(B2))), IF(UPPER(A2) = UPPER(B2), "OK","Review"),"")
Where it starts to not work correctly is when either Column A and/or B does not contain a value.
Currently if either A or B do not contain a value, Column C is blank and I want it to contain "Review"
So I need to fix the IF statement to work for the following scenarios as well.
4) If Column A or B do not contain a value, the IF statement should populate Column C with "Review".
5) If Column A and B are both blank, Column C should also be blank
Any help or suggestions would be greatly appreciated.
Thanks.
Bookmarks