Forum Discussion
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 like to put Family on the coverage tier. Thank you!
1 Reply
=IF(COUNTIFS([MEMBER SSN], [@[MEMBER SSN]], [DEPENDENT SSN], "<>"), "Family", "Individual")
