Can't rework the formula

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

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
 
hi
=IF(OR('Hskp Assign'!C10={"","BLOCK","S"}),"",'Hskp Assign'!C10)

that should cover BLOCK or S.

regards
FSt1
 
=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.
Click to expand...

Is that an additional condition or is it a new (the only) condition?
 
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
 
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
 
Back
Top