Formula Text field based on number field

Question

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 &amp; [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 &amp; [Total monthly income] is equal to or greater than $1795.83 BUT less than $5175.00, then display "Eligible", If over $5175.00,&nbsp; then"Ineligible"

------------------------------Ermias Bean------------------------------

paulpeterson1 · Answer

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

markshnier__you · Answer

I think that Paul's formula needs to be adjustedIf([Total Number of Members in the Household] =&nbsp;1&nbsp; and&nbsp;&nbsp;[Total monthly income]&nbsp;&gt;=$1329.17 and&nbsp;[Total monthly income] &lt;&nbsp;$4529.17,&nbsp; "Eligible",
[Total Number of Members in the Household] =&nbsp;1 and&nbsp;[Total monthly income] &gt;&nbsp;$4529.17, "Ineligible",[Total Number of Members in the Household] =&nbsp;2&nbsp; and&nbsp;&nbsp;[Total monthly income]&nbsp;&gt;=&nbsp;$1795.83 and[Total monthly income] &lt;&nbsp;$5175.00,&nbsp; "Eligible",
[Total Number of Members in the Household] =&nbsp;2&nbsp; and&nbsp;[Total monthly income]&nbsp; &gt; $5175.00,&nbsp; "Ineligible")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

Great catch, thanks Mark!
------------------------------Paul Peterson------------------------------

Forum Discussion

Formula Text field based on number field

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"

I think that Paul's formula needs to be adjusted

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

[Total Number of Members in the Household] = 1 and [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 Number of Members in the Household] = 2 and [Total monthly income] > $5175.00, "Ineligible")

Related Content

Add hyphens to phone number field

Roundup whole number

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Invoice Number Formula

Color Code Date Field based on Formula

Forum Discussion

Formula Text field based on number field

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"

I think that Paul's formula needs to be adjustedIf([Total Number of Members in the Household] = 1 and [Total monthly income] >=$1329.17 and [Total monthly income] < $4529.17, "Eligible",

[Total Number of Members in the Household] = 1 and [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 Number of Members in the Household] = 2 and [Total monthly income] > $5175.00, "Ineligible")

Add hyphens to phone number field

Roundup whole number

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Invoice Number Formula

Color Code Date Field based on Formula

I think that Paul's formula needs to be adjusted

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

[Total Number of Members in the Household] = 1 and [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",