Formula Field change based on 3-4 fields
I Need a Formula Text Field titled Eligibility with 2 possible options (Eligible and Ineligible). Someone is eligible based on the following responses Eligible 1. [Are you a Resident] = Yes...
Forum Discussion
Try this
IF(
[Are you a Resident] = "Yes"
and
([# of days since last service] >= 365 or IsNull([# of days since last service]))
and
[Are you at least 30 days behind on Rent] = "Yes"
and
[Age] > = 18, "Eligible", Ineligible")
IF(
[Are you a Resident] = "Yes"
and
([# of days since last service] >= 365 or IsNull([# of days since last service]))
and
[Are you at least 30 days behind on Rent] = "Yes"
and
[Age] > = 18, "Eligible", Ineligible")