Wildcard IF formula

[Goh Han]

Help for the needy... please?

Am trying to make a wildcard IF formula to work. The sample below doesn't
work because IF formula can only match by one word and not a word within a
few. I'm looking for a formula to detect the keyword "yellow" in each row in
column B and add in 15 working days for delivery date. Here's the table I'm
working on:

A B C
4/10/06 yellow shirt =IF(B2="yellow*",WORKDAY(A2,15,0)-1,"")
4/10/06 red hat
4/11/06 yellow pants
4/10/06 yellow belt
4/12/06 blue tie

Thank you in advance for any kind souls out there who can help...
--
Goh Han

[Biff]

Hi!

Try this:

=IF(ISNUMBER(SEARCH("yellow",B2)),WORKDAY(A2,15)-1,"")

Format the cells as DATE

Biff

"Goh Han" <gohhan2002(remove this)@yahoo.com> wrote in message
news:D1603013-786E-406B-96AF-F33124B3AA7B@microsoft.com...
> Help for the needy... please?
>
> Am trying to make a wildcard IF formula to work. The sample below doesn't
> work because IF formula can only match by one word and not a word within a
> few. I'm looking for a formula to detect the keyword "yellow" in each row
> in
> column B and add in 15 working days for delivery date. Here's the table
> I'm
> working on:
>
> A B C
> 4/10/06 yellow shirt =IF(B2="yellow*",WORKDAY(A2,15,0)-1,"")
> 4/10/06 red hat
> 4/11/06 yellow pants
> 4/10/06 yellow belt
> 4/12/06 blue tie
>
> Thank you in advance for any kind souls out there who can help...
> --
> Goh Han

[Goh Han]

You're..... a ...... genius!!!!

Thanks Biff :D
--
Goh Han


"Biff" wrote:

> Hi!
>
> Try this:
>
> =IF(ISNUMBER(SEARCH("yellow",B2)),WORKDAY(A2,15)-1,"")
>
> Format the cells as DATE
>
> Biff
>
> "Goh Han" <gohhan2002(remove this)@yahoo.com> wrote in message
> news:D1603013-786E-406B-96AF-F33124B3AA7B@microsoft.com...
> > Help for the needy... please?
> >
> > Am trying to make a wildcard IF formula to work. The sample below doesn't
> > work because IF formula can only match by one word and not a word within a
> > few. I'm looking for a formula to detect the keyword "yellow" in each row
> > in
> > column B and add in 15 working days for delivery date. Here's the table
> > I'm
> > working on:
> >
> > A B C
> > 4/10/06 yellow shirt =IF(B2="yellow*",WORKDAY(A2,15,0)-1,"")
> > 4/10/06 red hat
> > 4/11/06 yellow pants
> > 4/10/06 yellow belt
> > 4/12/06 blue tie
> >
> > Thank you in advance for any kind souls out there who can help...
> > --
> > Goh Han
>
>
>

[Biff]

You're welcome!

Biff

"Goh Han" <gohhan2002(remove this)@yahoo.com> wrote in message
news:AF116E38-267C-4464-99E4-54B4064DC8DE@microsoft.com...
> You're..... a ...... genius!!!!
>
> Thanks Biff :D
> --
> Goh Han
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> =IF(ISNUMBER(SEARCH("yellow",B2)),WORKDAY(A2,15)-1,"")
>>
>> Format the cells as DATE
>>
>> Biff
>>
>> "Goh Han" <gohhan2002(remove this)@yahoo.com> wrote in message
>> news:D1603013-786E-406B-96AF-F33124B3AA7B@microsoft.com...
>> > Help for the needy... please?
>> >
>> > Am trying to make a wildcard IF formula to work. The sample below
>> > doesn't
>> > work because IF formula can only match by one word and not a word
>> > within a
>> > few. I'm looking for a formula to detect the keyword "yellow" in each
>> > row
>> > in
>> > column B and add in 15 working days for delivery date. Here's the table
>> > I'm
>> > working on:
>> >
>> > A B C
>> > 4/10/06 yellow shirt =IF(B2="yellow*",WORKDAY(A2,15,0)-1,"")
>> > 4/10/06 red hat
>> > 4/11/06 yellow pants
>> > 4/10/06 yellow belt
>> > 4/12/06 blue tie
>> >
>> > Thank you in advance for any kind souls out there who can help...
>> > --
>> > Goh Han
>>
>>
>>