# Survey123 Connect Relevant Formula if field value between two numbers

109
1
05-23-2020 07:03 PM
Highlighted
New Contributor

I need help with the following formula to make a group of fields display based on a range of income and some other field values.

If apply_status = yes and entered_by = 211 -> display the group

OR

If apply_status = yes and how_many_people_live_with_you = me_and_1_other_person and income is between 33821 and 101460 -> display the group

OR

If apply_status = yes and how_many_people_live_with_you = live_alone and income is between 24981 and 74940 -> display the group

Here is what is not working:

(\${apply_status}='yes' and \${entered_by}='211') or (\${apply_status}='yes' and ((\${income}<='101460' or \${income}>='33821') and \${how_many_people_live_with_you} = 'me_and_1_other_person') or ((\${income}<='74940' or \${income}>='24981') and \${how_many_people_live_with_you} = 'live_alone'))

Thank you.

Tags (1)
1 Reply
Highlighted
New Contributor

Figured it out, I needed the income or's to be and's

((\${income} >= 24981 and \${income} <= 74490) and \${how_many_people_live_with_you} = 'live_alone') or ((\${income} >= 33821 and \${income} <= 101460) and \${how_many_people_live_with_you} = 'me_and_1_other_person')