If→Then→Else column with multiple criteria

Ask for Help
1

In a quiz app, I have an “‘Answer Selected’ is not empty” column and a “‘Answer Selected’ is wrong answer” column. Both of these are If→Then→Else columns.

Now I want to make a third If→Then→Else column that returns an answer (e.g., TRUE) based on two criteria: If ‘Answer Selected’ is not empty AND ‘Answer Selected’ is wrong answer.

How can I go about doing this?

Thanks in advance for your assistance.

1 Like
2
  • If Answer selected is empty, then null (leave empty)
  • If Answer selected is wrong answer, then true
1 Like
3

Was about to reply but u got the master replying in a sec :slight_smile:

1 Like
4

Thanks! It worked.

1 Like
5

That sounds like a lot of If-Then-Else columns. Can you describe what you’re trying to do here so maybe we can optimize the number of columns you can use for your case?

1 Like