How to create a smart excel table that proceses a YES/NO decision tree and outputs an outcome

Im pretty new to this Excel stuff so i figured ill put out a question here and see how i go: I'm making a table that would automatically follow the process of a yes/no decision tree to give a determ...