AnsweredAssumed Answered

match field to multiple possible results in other field?

Question asked by ezeitgeist on Dec 18, 2017
Latest reply on Dec 24, 2017 by user19752

Is there a way to script so that if the result in one field matches one of the results (either a set of results or is within a given range) it registers a match?


Example1. Field 1 = 5, Field 2 = 3,5,7

Would want to show match, boolean, etc.


Example2. Field 1 = 5, Field 2 = Some way to write range from 3 to 7

Would want to show match.


I currently have a setup of an IF statement for direct matching of fields, but realized in some cases it needs to match either a set of possible correct answers or if it falls within a range it is correct.