4 Replies Latest reply on Jun 1, 2010 5:24 PM by kingsley47

    Easy One, If Statements

    kingsley47

      Title

      Easy One, If Statements

      Post

      This one is pretty simple. I'm almost certain the issue is in how im wording it but I can't seem to figure out the correct way to do so. I need an if statement that works along these lines if (Field 1 = "" ; "" ; "Normalized at" Field 1 Value "for" Field 2 Value "hours.   Air cooled"). I am putting this function into the calculation field in the autofill function for a 3rd field.

       

      The issue I'm having is in the insertion of the values from field 2 and 3. I have tried using the Value list items function but I am still having problems. Could someone please show me what I am missing. A comma? A semicolon? another function?