Is there a way to ask 2 ifelse questions for one calculated field

Question & Answer
, ,
1

For example, for one calculated field I would like to do something like:
ifelse (title=A AND data = A, 0, 1)
ifelse (title = A AND data = B, 1, 0)
How can I have several if statements for one calculated field? Thank you in advance

2

Hi
You can use nested if else to achieve the results. Also you can have look on switch statement and use accordingly.

3

Thank you so much!!!

1 Like