Can't rework the formula
in [Functions]
|
From: Malcolm on 31 May 2010 14:17 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
From: FSt1 on 31 May 2010 15:42 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 >
From: T. Valko on 31 May 2010 15:59 >=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" <Malcolm(a)discussions.microsoft.com> wrote in message news:58E492CC-B225-4B12-8569-6723D48DEE6A(a)microsoft.com... > 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 >
From: Malcolm on 31 May 2010 17:32 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" <Malcolm(a)discussions.microsoft.com> wrote in message > news:58E492CC-B225-4B12-8569-6723D48DEE6A(a)microsoft.com... > > 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 > > > > > . >
From: T. Valko on 31 May 2010 17:44
Ok, if I understand what you want then try: =IF('Hskp Assign'!C10="s","s","") -- Biff Microsoft Excel MVP "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message news:45AD1D9F-0D57-481E-9F0B-4F91DF1DE252(a)microsoft.com... > 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" <Malcolm(a)discussions.microsoft.com> wrote in message >> news:58E492CC-B225-4B12-8569-6723D48DEE6A(a)microsoft.com... >> > 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 >> > >> >> >> . >> |