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
Here's a simplified formula:
var bool residentEligible = [Are you a Resident?] = "Yes" AND [Age] >= 18;
var bool singleMemberHousehold = [Total Number of Members in the Household] = 1;
var bool payEligible = [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;
var text eligibile = ($residentEligible && singleMemberHousehold) && $payEligible;
if ($eligibile, "Eligible", "Ineligible")
------------------------------
Neil Schneider
------------------------------
var bool residentEligible = [Are you a Resident?] = "Yes" AND [Age] >= 18;
var bool singleMemberHousehold = [Total Number of Members in the Household] = 1;
var bool payEligible = [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;
var text eligibile = ($residentEligible && singleMemberHousehold) && $payEligible;
if ($eligibile, "Eligible", "Ineligible")
------------------------------
Neil Schneider
------------------------------
- There's an error in the formula, should be:
var bool residentEligible = [Are you a Resident?] = "Yes" AND [Age] >= 18;
var bool singleMemberHousehold = [Total Number of Members in the Household] = 1;
var bool payEligible = [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;
var bool eligibile = ($residentEligible && singleMemberHousehold) && $payEligible;
if ($eligibile, "Eligible", "Ineligible")
------------------------------
Neil Schneider
------------------------------- Final edit - sorry used wrong syntax for 'AND"...
var bool residentEligible = [Are you a Resident?] = "Yes" and [Age] >= 18;
var bool singleMemberHousehold = [Total Number of Members in the Household] = 1;
var bool payEligible = [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;
var bool eligibile = ($residentEligible and singleMemberHousehold) and $payEligible;
if ($eligibile, "Eligible", "Ineligible")
------------------------------
Neil Schneider
------------------------------