Set-up Of IF AND OR Formula

• =IF((B2<>"completed",G2=B2," ") or (C2<>"completed",G2=D2," ") or (E2<>"completed",F2=D2," "))

This is what I would like to do, but I do not remember the best to handle an "If" "Or" formula.

I need to pull names from a column if the column to the right does not have the word "completed". I have three columns of names.
Column A - Name and Column B "completed" or Blank"
Column C - Name and Column D "Completed" or Blank"
Column E - Name and Column F "completed or Blank"

• Re: Set-up Of &quot;if&quot; &quot;or&quot; Formula?

Is this statement checking on each line or is it a one time thing? What happens if its completed in all three cases?

Where will this formula live? Is it checking each case separatly or as one formula?

• Re: Set-up Of &quot;if&quot; &quot;or&quot; Formula?

=IF(OR(AND(B2<>"completed",G2=B2),
AND(C2<>"completed",G2=D2),
AND(E2<>"completed",F2=D2)),
"","do something that you din't say")

HTH

Bob

• Re: Set-up Of &quot;if&quot; &quot;or&quot; Formula?

This is a one time formula and it is all in the same line.
What I need is to build a list in column G with the names of those people that have not completed their assignement "completed"
The names are in columns A, C and E and the word "completed" or blank" in columns B, D, F

• Re: Set-up Of &quot;if&quot; &quot;or&quot; Formula?

You can't actually use a formula to set the value of another cell, which appears to be what you want to do.

Boo!:yikes:

• Re: Set-up Of &quot;if&quot; &quot;or&quot; Formula?

I'm going to use the Vlookup rather than trying to figure out the structure of this "If" "or" formula.

I believe the Vlookup will work.

Thank you, you can close this post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!