Wildcard IF formula
You're welcome!
Biff
"Goh Han" <gohhan2002(remove wrote in message
...
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 wrote in message
...
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
|