Skip to main content
Question

Formula Field change based on 3-4 fields

  • September 28, 2018
  • 0 replies
  • 9 views
Forum|alt.badge.img+7
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
2. [# of days since last service] >or=365 or null
3. [Are you at least 30 days behind on Rent] = Yes
4. [Age] > or = 18


Someone is Ineligible based on the following responses

Ineligible 

1. Are you a Resident = No
2. # of days since last service < 365
3. Are you at least 30 days behind on Rent = No
4. [Age] < 18

    This topic has been closed for replies.

    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")





    Terms & ConditionsAccessibility statement