AnsweredAssumed Answered

two fields will determine the third

Question asked by tdeppen on Feb 4, 2015
Latest reply on Feb 4, 2015 by Mark_M

Title

two fields will determine the third

Post

I am trying to set up some type of "if" or "case" statement, but I have two tests to determine the outcome of a third field and I am not sure how to go about it. Here is my formula:

If "form number field" = "X" and "type of order field" = "exact reprint" make "machine field" "46" ; (otherwise) "" (leave blank). Not sure what statement and language I should use to get this to work. I am assuming maybe a nested if statement or case statement as my best guest. 

Outcomes