Can't rework the formula

[Malcolm]

Yesterday I was given a solution to a problem I had when copying text from
cells in the source sheet to the destination sheet. The formula:
=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)
was to prevent text from copying to the destination sheet if the word
“BLOCK†appeared in the source sheet. I have been trying to rework the
formula to only copy the text if the letter “S†appears in the source sheet.
I have not had any success. Please help!
Thanks,
Malcolm

 

[FSt1]

hi
=IF(OR('Hskp Assign'!C10={"","BLOCK","S"}),"",'Hskp Assign'!C10)

that should cover BLOCK or S.

regards
FSt1

 

[T. Valko]

=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10)

I have been trying to rework the formula to only
copy the text if the letter "S" appears in the source sheet.

Is that an additional condition or is it a new (the only) condition?

 

[Malcolm]

Biff, Hi,
Since you gave me the original formula, let me apologize for not being more
precise. It is a new (the only) condition.

Best regards,
Malcolm

 

[T. Valko]

Ok, if I understand what you want then try:

=IF('Hskp Assign'!C10="s","s","")

 

[Malcolm]

Biff, Hi,
This one did it big guy. Thank you for saving my bacon on more than one
occasion. You are the best. Thanks again.

Best Regards,
Malcolm

 

[T. Valko]

You're welcome. Thanks for the feedback!