two fields will determine the third
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.