Formula Help
I have an existing formula below that needs tweaking. I want the first conditions in bold to display "Ineligible" if the criteria is not met along with the other conditions. For example, If Are you a ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
If(
[Are you a Resident?] = "No", "Ineligible",
[Age] < 18, "Ineligible",
[Total Number of Members in the Household] = 1 and [Total monthly income for the household for past 30 days (Net income/Take home pay)?] > 1329.17 and
[Total monthly income for the household for past 30 days (Net income/Take home pay)?]<= 4529.17, "Eligible",
[Total Number of Members in the Household] = 1 and [Total monthly income for the household for past 30 days (Net income/Take home pay)?]> 4529.17, "Ineligible")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If(
[Are you a Resident?] = "No", "Ineligible",
[Age] < 18, "Ineligible",
[Total Number of Members in the Household] = 1 and [Total monthly income for the household for past 30 days (Net income/Take home pay)?] > 1329.17 and
[Total monthly income for the household for past 30 days (Net income/Take home pay)?]<= 4529.17, "Eligible",
[Total Number of Members in the Household] = 1 and [Total monthly income for the household for past 30 days (Net income/Take home pay)?]> 4529.17, "Ineligible")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------