I need to pull 6 questions into a 1/0 (true/false) option. I am open to adding additional fields and hiding them, but am currently at a loss.
The final scoring statement is: "If there is a single parent with 2+ children, and/or a child aged 11 or younger, and/or a current pregnancy, then score 1. If there are two parents with 3+ children, and/or a child aged 6 or younger, and/or a current pregnancy, then score 1 for family size."
All of the needed information is collected in radio buttons.
Am I able to do something similar to the following?
=IF(Parents.1 (AND (SUM childrenwith, childrennwith.... etc?
I'm not sure how far it will let me nest and how to format the various calculations. Ideas?