Need help for an "if statement"
Sorry because I'm sure this an extremely basic question for most. I need help with an If statement. I can get each of these to work independently but when I use them both together it's no go. I get a message stating: "An operator (e.g. =, -, *, ... is expected here"
Basically, what I'm trying to do is get subject/verb agreement for a letter in a mass mailing I'm sending out. If the field 'number of children' equals 1, i want the 'ChildChildren' field to read "child". If the number is greater than 1, I want the field to read "children"
Here are the two statements that will work on their own. How do I use them together?
If( GetAsNumber(Number of Children) = 1; "child"),
If( GetAsNumber(Number of Children) > 1; "children")