Forum Discussion

Del's avatar
Del
Qrew Cadet
6 years ago

Formula Text field based on number field

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 equ...
Formulas and functions
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
6 years ago

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