IF?

[daknight]

Hi!
Thanks in advance for any help. I think this one will be easy for the masters

I am collecting test data and if I have a certain type of failure, I need the inspector to test more samples.

data entry is in rows, and if any one or more of 5 other cells (E14, G14, I14, K14 or M14)have an "S" entered, I want O14 to say "TEST MORE!"

I have this formula working ----- =IF(E14="S", "TEST MORE!")
but how do I get it to include G, I, K and M?

Thanks for your help!
Darla

 

[VoG]

Try

=IF(OR(E14="S",G14="S",I14="S",K14="S",M14="S"), "TEST MORE!","")

 

[Jonmo1]

Is it possible for there to be "S" in any of the intermediate cells(F14,H14,J14,L14) ?

If not, you can use countif

=IF(COUNTIF(E14:M14,"S")>0,"TEST MORE!","")

 

[T. Valko]

Hi!
Thanks in advance for any help. I think this one will be easy for the masters

I am collecting test data and if I have a certain type of failure, I need the inspector to test more samples.

data entry is in rows, and if any one or more of 5 other cells (E14, G14, I14, K14 or M14)have an "S" entered, I want O14 to say "TEST MORE!"

I have this formula working ----- =IF(E14="S", "TEST MORE!")
but how do I get it to include G, I, K and M?

Thanks for your help!
Darla

One way:

=IF(LEFT(E14&G14&I14&K14&M14)="S","Test More","")

 

[daknight]

Thank you ALL SO MUCH for your help. All suggestions work, so I appreciate seeing the different options!! always learning!
thanks!
Darla

 

[T. Valko]

Thank you ALL SO MUCH for your help. All suggestions work, so I appreciate seeing the different options!! always learning!
thanks!
Darla

You're welcome. Thanks for the feedback!

 

[daknight]

could you please help me add to this formula??? (thanks SO much if you can

this is the formula I am using for now in cell O14:

=IF(COUNTIF(E14:M14,"S")>0,"TEST MORE!","")
this signals the inspector if there is an "S" type failure in E14,G14,I14, K14, M14 to test more

could I also add that if Cells F14, H14, J14, L14 OR N14 contain a 3, 4, 8 or 9 , Cell O14 would say "REJECT" ??
This is way too sticky for me to figure out!
Thanks a lot!
Darla

 

[Jonmo1]

Glad to help...

Again, provided the 3,4,8 or 9 will NOT appear in the intermidate cells as mentioned in my previous post..

=IF(COUNTIF(E14:M14,"S")>0,"TEST MORE!",IF(SUM(COUNTIF(E14:M14,{3,4,8,9}))>0,"REJECT",""))

 

[daknight]

thank you very much. that works perfectly!
Darla