Which formula would I need for this please?

So I am going through some data. See attached screenshot for what I want to achieve.

Basically, I need the following.

* If Question is Yes and Comment is Yes then completion column will need to be "Yes"

* If Question is Yes and Comment is No then completion column will need to be "Yes"

* If Question is N/A and comment is Yes then completion column will need to be "Yes"

* If Question is N/A and Comment is No then completion column will need to be "No"

* If Question is Not completed and Comment is No then completion column will need to be "No"

* If Question is Not completed and Comment is Yes then completion column will need to be "No"

Based on those 6 scenarios answers for "Question" and "Comment" columns, I need a formula so it can work out correct outcome in the "Completion" column. Thank you.