Formula Help

[HeatherJ]

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

 

[Luke M]

=IF(G2="bail",B2&","&G2&","&H2,"")

 

[Mike H]

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.

 

[Gary''s Student]

=IF(ISERROR(FIND("bail",G2)),"",B2 & "," & G2 & "," & H2)