software

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 quot;yellowquot; 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=quot;yellow*quot;,WORKDAY(A2,15,0)-1,quot;quot;)
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

Hi!

Try this:

=IF(ISNUMBER(SEARCH(quot;yellowquot;,B2)),WORKDAY(A2,15)-1,quot;quot;)

Format the cells as DATE

Biff

quot;Goh Hanquot; lt;gohhan2002(remove gt; wrote in message
news
gt; Help for the needy... please?
gt;
gt; Am trying to make a wildcard IF formula to work. The sample below doesn't
gt; work because IF formula can only match by one word and not a word within a
gt; few. I'm looking for a formula to detect the keyword quot;yellowquot; in each row
gt; in
gt; column B and add in 15 working days for delivery date. Here's the table
gt; I'm
gt; working on:
gt;
gt; A B C
gt; 4/10/06 yellow shirt =IF(B2=quot;yellow*quot;,WORKDAY(A2,15,0)-1,quot;quot;)
gt; 4/10/06 red hat
gt; 4/11/06 yellow pants
gt; 4/10/06 yellow belt
gt; 4/12/06 blue tie
gt;
gt; Thank you in advance for any kind souls out there who can help...
gt; --
gt; Goh Han
You're..... a ...... genius!!!!

Thanks Biff
--
Goh Hanquot;Biffquot; wrote:

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

You're welcome!

Biff

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