Skip to main content
Question

Formula Text field based on number field

  • June 3, 2020
  • 0 replies
  • 28 views
I performed this via dynamic form rules in the past but want a formula text field for the following conditions,

If

[Total Number of Members in the Household] = 1 & [Total monthly income] is equal to or greater than $1329.17 BUT less than $4529.17, then display "Eligible", If over $4529.17, then "Ineligible"


[Total Number of Members in the Household] = 2 & [Total monthly income] is equal to or greater than $1795.83 BUT less than $5175.00, then display "Eligible", If over $5175.00,  then"Ineligible"


------------------------------
Ermias Bean
------------------------------
This topic has been closed for replies.

If([Total Number of Members in the Household] = 1  and  [Total monthly income] >=$1329.17 and 
[Total monthly income] < $4529.17,  "Eligible",
[Total monthly income] > $4529.17, "Ineligible",
[Total Number of Members in the Household] = 2  and  [Total monthly income] >= $1795.83 and
[Total monthly income] < $5175.00,  "Eligible",
[Total monthly income]  > $5175.00,  "Ineligible")



------------------------------
Paul Peterson
------------------------------
Terms & ConditionsAccessibility statement