Formula to Return Yes based on a few scenarios.

NOW SOLVED. Thank you.
Test for formula.xlsx
Hi all,

I have a spread sheet for student grades, the subjects are split into Buckets.
I need a Column to say Yes or No based on this Scenario.

I currently have a column returning yes for the following.
1. Is bucket 1 complete
2. Is Bucket 2 complete
3. Is bucker 3 complete
4. Does bucket 2 spares added with bucket 3 make bucket 3 complete.

in a new column I need to return yes or no based on this.
(using the list above).

Scenario 1
1. returns NO - column X Returns no.

Scenario 2.
1. Returns Yes
2. Returns No - Column X Returns no.

Scenario 3.
1. Returns Yes
2. Returns Yes
3. Returns yes - Column X Returns Yes

Scenario 4.

1. Returns Yes
2. Returns Yes
3. Returns No - Then ask if -
4 Returns yes - if 4 returns yes column x returns Yes. if No, column X returns No.

Hope this makes sense

Thanks in advance.

Try

A2=IF(TRIM(B2)="NO","NO",IF(AND(TRIM(B2)="YES",TRIM(C2)="NO"),"NO",IF(AND(TRIM(B2:D2)="YES"),"YES",IF(AND(TRIM(B2:E2)="YES"),"YES","NO")))) with CRTL+SHIFT+ENTER and drag down

Try this formula in A2 and down:

Please Login or Register  to view this content.

Let me know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. Hope that you have a good day.