AnsweredAssumed Answered

Need help for an "if statement"

Question asked by pugmum on Jan 7, 2010
Latest reply on Jan 7, 2010 by pugmum

Title

Need help for an "if statement"

Post

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")

Outcomes