A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't rework the formula



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 07:17 PM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
 
Posts: 106
Default 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

  #2  
Old May 31st, 2010, 08:42 PM posted to microsoft.public.excel.worksheet.functions
FSt1
external usenet poster
 
Posts: 2,788
Default 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

  #3  
Old May 31st, 2010, 08:59 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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



  #4  
Old May 31st, 2010, 10:32 PM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
 
Posts: 106
Default 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



.

  #5  
Old May 31st, 2010, 10:44 PM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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



.



  #6  
Old June 1st, 2010, 02:10 AM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
 
Posts: 106
Default 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

  #7  
Old June 1st, 2010, 02:12 AM posted to microsoft.public.excel.worksheet.functions
malcolm
external usenet poster
 
Posts: 106
Default 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



.



.

  #8  
Old June 1st, 2010, 02:53 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default 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



.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.