Nested IFs based on list and text value

The formula for the Auto value (column B) has to satisfy the following parameters
The Auto Value has to return the following
1. If Values in column A says NPV and column C has Yes, the value in column B should say Works
2. If Values in column A says NPV and column C has No, the value in column B should say Does not work
3. If Values in column A doesn't have NPV, the value should be 1 if I select Yes in Column C or 0 if I select No in column


See attached Excel spreadsheet.

You can use this formula in cell B2:

=IF(A2="NPV",IF(C2="Yes","Works","Does not work"),IF(C2="yes",1,0))

then copy down as required.

Hope this helps.

Pete