compare the cells if not blank

[heidiau]

123.png


I want to have the final results as shown in column F. The conditions are as follows:

If B2 or C2 is not blank, check whether D2=B2 or E2=C2 and return "Y" if D2<>B2 or E2<>C2.

I have tried many formulas but they did not end up what I wanted. Please help. Thanks.

[Kaper]

Use:

Please Login or Register  to view this content.

and copy down

[bebo021999]

Use:

Please Login or Register  to view this content.

and copy down

It should work with one more criteria

Please Login or Register  to view this content.

[Kaper]

I don't think so.
In my opinion the logic behind is like this:
Check if Fixed date or time is given. If not - ignore scheduled date and time even if it's set.
Only if Fixed date or time is given, then check respective scheduled date or time: if it's the same do nothing, if different - display Y for reminder

[bebo021999]

Only if Fixed date or time is given, then check respective scheduled date or time: if it's the same do nothing, if different - display Y for reminder

Just guessing until getting final instruction from OP
Your logic are moving forward: Fix then Schedule.
How about backward: Schedule then Fix?
For instant: If, fixed date and time is set (B and C is occupied), but D and E is blank.
Yours returns "Y" while it should not.

[heidiau]

I don't think so.
In my opinion the logic behind is like this:
Check if Fixed date or time is given. If not - ignore scheduled date and time even if it's set.
Only if Fixed date or time is given, then check respective scheduled date or time: if it's the same do nothing, if different - display Y for reminder

Yes, this is what I meant. I wanted to check D & E against B & C. If B & C are blank, I don't need to do the checking.
I tried this formula before but putting " " instead of "". That's why it did not end up what I wanted.
If I twists bebo021999's formula a bit, it can filter one more criteria: =IF(OR(AND(B2<>"",D2<>"No lesson",B2<>D2),AND(C2<>"",E2<>"",C2<>E2)),"Y","")

Thanks Kaper and bebo021999.