Thread
:
If formula with text string help please
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
If formula with text string help please
=IF(A2<1,"","Vacine " &
IF(AND(A2=1,VALUE(MID(B2,FIND("/",B2)+4,4))2003),"Given","due"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"ferde" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett