if-then-else statement in locked text box

[mjwillyone]

Friends,

I want to create an if-then-else expression that will determine the number of people in a family. It is assumed that there is a head-of-household in all cases. Also, if there is a spouse allowance, there must be a spouse. I thought that determining the number of people in the family can be found by using the following expression but it does not work. It will not even take the expression ...

if [Spouse_income_allowance] >1,2+[Number_of_children], 1+[Number_of_children]

Any ideas?

Thank you,
Mike

 

[Pat Hartman]

=IIf([Spouse_income_allowance] >1, 2+[Number_of_children], 1+[Number_of_children])

 

[mjwillyone]

Thanks!

Pat,

Thank you very much for your help. Your if-then-else statement worked perfectly!

Mike