Constraint based on previous answer

Hi everyone,

I was wondering if someone can help me?
I use xls to make forms and want to know if this type of constraint is possible?

I would like to put in a constraint based on the answer from the previous question.
For example the first question is "How many females are in this household?" and the second question is "how many lactating females are in this household?" - I want to make sure that the answer for the number of lactating females is lower or equal to the total number of females in the household.
Is there a way to do this?

Thank you in advance!

Hi Penelope, sure, hope I can help!

Please see attached file and see if that makes sense!

Jannaexample_lactating_women.xlsx (15.9 KB)


Thank you so much Janna!
This is perfect! have a great day.