Easy One, If Statements
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?