Can't rework the formula
 

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

Can't rework the formula
 

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

that should cover BLOCK or S.

regards
FSt1

"Malcolm" wrote:

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

Can't rework the formula
 

=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?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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

Can't rework the formula
 

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" wrote:

=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?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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



.

Can't rework the formula
 

Ok, if I understand what you want then try:

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


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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" wrote:

=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?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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



.

Can't rework the formula
 

FSt1, Hi,
Your solution did not directly address my problem, but that was my fault
because I was not clear. However, your formula helped me address several
other issues, that I had on another worksheet so your reply helped me a load.
Thanks again for all your invaluable help.

Best Regards,
Malcolm

"FSt1" wrote:

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

that should cover BLOCK or S.

regards
FSt1

"Malcolm" wrote:

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

Can't rework the formula
 

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" wrote:

Ok, if I understand what you want then try:

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


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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" wrote:

=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?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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



.



.

Can't rework the formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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" wrote:

Ok, if I understand what you want then try:

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


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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" wrote:

=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?


--
Biff
Microsoft Excel MVP


"Malcolm" wrote in message
...
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



.



.