Formula Help - Multiple Conditions

[hmltnangel]

Hi folks,

Somedays we just have a complete mind blank. Today, is that day for something that should be really simple.

I have

Column C - check column - displays "Yes" or Blank
Column D - "Employee ID"
Columns F-M - Employee IDs in the Structure of Col D Employee

I want to have a formula that does the following:

If Col C = yes, then display "Yes"
or
If Col D appears in Col F-M in any row where Col C = Yes then display "Yes"

Cheers

 

[steve the fish]

The way you have described that you just need to test if column C is yes. I presume that isnt correct.

 

[Radoslaw Poprawski]

If formula have 3 arguments:
Logical test -> here you need to put 2 conditions, that will result in True if 1 of them is met, to do so, use OR() formula and in each argument separtely, place each of your conditions i.e. OR( logical test1; logical test2)
Value if true -> place what you want to happen if the logical test result is True i.e "Yes" or some formula.
Value if false -> place what you want to happen if the logical test result is False i.e blank "" as double quote

 

[hmltnangel]

Thats the easy bit.

Its the testing If Col D appears in Col F-M IF C = Yes that I cant work out

 

[steve the fish]

You have misunderstood. What you have described is if column C is yes then produce yes. The 2nd condition also insists column C is yes. Therefore anything else is not required. Easy to do but would produce exactly the same result as if you just tested if C is yes.

 

[hmltnangel]

Col C - is a list of Employee IDs
Col D - says "Yes" if that Employee lives in Antarctica
Col F-M are also a list of Employee IDs (basically the whole Management Structure for the Employee in Col C)

So lets say its (very basically) Like This

Col C - Dave
Col D - Yes

So Dave lives in Antarctica

Now Lets Say We look at Joe.

If Joe Lives in Antarctica then i want "Yes". Thats Easy.

If Dave exists anywhere in Columns F-M of Joes row (ie - if he is in the structure of Joe) then I also want "Yes". BUT if Dave didnt live in Antarctica, then I want "No"

 

[steve the fish]

Provide some sample data and maybe that will help. Not an image. Copy and paste from excel.