Cross referencing outcomes are genuine

ExcelAmateur2014

New Member
Joined
Dec 17, 2014
Messages
32
Hi

I am looking to find some sort of formula which will check the answers to 10 questions before it an ascertain whether the Overall Outcome is consistent with the answers to the previous questions and if the overall outcome is inconsistent then it would flag the result in Red so that I can easily identify the potential error.

I have uploaded the data to drop box via the below link


https://app.box.com/s/tcvbkidj578zpart4awemlm1f0eecevu


To summarise, SUITABLE outcome can be contradicted by a single NO or UNCLEAR Question before it. UNSUITABLE outcome can only be affected by an UNCLEAR question before it, Unclear question would override everything.

With SUITABLE overall outcome this would be OK as long as there are not any NO or UNCLEAR outcomes in the previous Questions. Or even better would be that it only consists of YES and N/A outcomes and MUST have at least 1 YES in the Question sections
With UNSUITABLE overall outcome this would be OK as long as there are not any UNCLEAR outcomes in the previous Questions. Or even better would be that it only consists of YES, NO and N/A outcomes and MUST have at least 1 NO in the Question sections
With UNCLEAR overall outcome this would only be OK if at least 1 UNCLEAR in the Question sections

Thanks in advance
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,018
Messages
5,856,837
Members
431,836
Latest member
jj0911

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top