Prev: extracting sheets on the basis of Row character
Next: concatenate will not paste special
From: HeatherJ on 2 Jun 2010 11:26
I need a formula (will be in L2) to do the following--

IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
H2 separated by commas.

If G2 does not contain the text "bail" then I want L2 to remain blank.

Any help would be appreciated. Thanks! Heather
From: Luke M on 2 Jun 2010 12:08
=IF(G2="bail",B2&","&G2&","&H2,"")

--
Best Regards,

Luke M
"HeatherJ" <HeatherJ(a)discussions.microsoft.com> wrote in message
news:B7DF0AE9-6B35-4EFA-8A93-9C053B1AB388(a)microsoft.com...
>I need a formula (will be in L2) to do the following--
>
> IF G2 contains the text "bail" then L2 should be the contents of cells B2
> G2
> H2 separated by commas.
>
> If G2 does not contain the text "bail" then I want L2 to remain blank.
>
> Any help would be appreciated. Thanks! Heather


From: Mike H on 2 Jun 2010 12:12
Hi,

Try this in L2

=IF(G2="Bail",B2&","&G2,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"HeatherJ" wrote:

> I need a formula (will be in L2) to do the following--
>
> IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
> H2 separated by commas.
>
> If G2 does not contain the text "bail" then I want L2 to remain blank.
>
> Any help would be appreciated. Thanks! Heather
From: Gary''s Student on 2 Jun 2010 12:12
=IF(ISERROR(FIND("bail",G2)),"",B2 & "," & G2 & "," & H2)
--
Gary''s Student - gsnu201003
 | 
Pages: 1
Prev: extracting sheets on the basis of Row character
Next: concatenate will not paste special