How to use IF for giving an output

How to use multiple if conditions for a result to show up.

Drop down has A B C

IF A B C are all there D will show up
IF B C are there E will show up

likewise

1 Like