If formula with text string help please
The formula you gave me works great but I forgot to consider that B2 may
be empty and so now I get a value error using the formula you suggested
because there is no date to calculate...is there an easy fix for this ?
So if A2 =1 and B2 is empty ...then C 2 = Vaccine due
Thank you again for your help
"ferde" wrote:
In column C ..... I would like to ask the question....if A2=1 and B2 which
is formatted as "general" has a year date in its string which is 2003 the
answer = "vaccine given" but if the year date is <2003 then the answer
="vaccine due". Also I should add if A2 is 0 then the answer =na.
I'm not sure how to proceed and any help would be appreciated.
A B C
1 HIST-Pnuemo-10/01/2007 vaccine given
0 HIST-Pnuemo-07/24/2009 na
1 HIST-Pnuemo-01/01/2003 vaccine due
|