Hello all,I am trying to create an IF statement with multiple conditions that will return a yes or no depending on if one of the conditions are met.
Here is a sample of my formula:
If(([Related Candidate (ref) - Job Code])="AACH25,AACH41,ADEV31,ADEV32,ADEV33,ADEV34,ADEV41,ADEV42,ADEV43,"<Font color=RED>YES</font>","null")
QB accepts the formula, however, it does not work (I think because it is looking at the conditions as a whole). Do I need to write an IF statement for each of the "AACH25,AACH41,ADEV31,ADEV32,ADEV33,ADEV34,ADEV41,ADEV42,ADEV43" conditions, or can I use OR in between? I have about 320 codes that I need to include so if there's any easier way to do this that would be fantastic.