PDA

View Full Version : Formula: Is one of several Codes in one of several Fields?



generalledger
2016-10-15, 01:54 PM
I need to Add A Custom Column with a formula that looks for any of several codes in any of a few fields. For example,

=If Code A, B, or C is in Field 1, 2 or 3 Then "True" Else "False"

What might be the most efficient way to do this? Do I need to nest many If statements?

Thank you.

Bill Szysz
2016-10-16, 11:01 AM
Hi generalledger,
Check attachement.... is that what you want?

Regards