I have a very similar instance but want to take it a bit further. I have 2 name fields that I want to Compare. Except I want to display the name once both fields are filled in. They will be the same name so selecting whose name will not be an issue.
=IF(OR(H56="",H61=""),"") <--- This part works great.
If H56="" OR H61="" then display blank, but if both H56 and H61 have (A NAME IT THEM) then display (the name).
Bookmarks