Formula to enter new value in a cell

Hi,    I'm trying to find a formula for the sample below that could enter in another cell if the member has dependents or not (Coverage Tier). Like the1st one, the member has family, so I would lik...