Assistance with If Then Else

Hi everyone, I am fairly new to Excel formulas and could use your help.  Here is an example of my data I am working with: Owner 1 Owner 2 Owner 3 Owner 4 Owner 5 Owner 6 Owner 7 Lawrenc...