Hi There -

I have a set of data (dates and cells to check if dates match).
So I have a date from our database (this is a formula), then a cell to check if it matches the next cell, then a date we manually enter.
The cell that checks if the dates match returns the following values: "OK" - if they match, "UPDATE" - if they do not match, or nothing if they are both blank.

It's to make sure our notes match what's in our database.


What I want to do is have a cell at the beginning that will return the value "UPDATE" if ANY of them say "UPDATE".
If none of them say update AND two specific cells say "OK", I want it to return the value "OK". (I believe this would just be a formula in the false end of an IF formula, but I can't piece together the other parts)
Otherwise I would like it to be blank.

I feel like the formula should be pretty similar to the one I have already, but because the cells may have different values in them I can't just do a solid "does this=that".


Any help on this matter would be greatly appreciated - Thanks!
-Ashley