generalledger
New member
- Joined
- Oct 15, 2016
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Location
- New Jersey, USA
- Excel Version(s)
- 2016
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.
=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.