Hi All,
Is is possible - within a formula (e.g. to calculate a new column ) - to have an IF statement with two conditions, e.g.
If FIELD A contains “dog” and FIELD B contains “cat” then “pets” ELSE …etc…
I know we can reproduce this effected with a nested if statement, but that requires a lot more work in the case I am dealing with now.
Thank you