5 Replies Latest reply on Jan 7, 2010 2:26 PM by pugmum

    Need help for an "if statement"

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