=IF(T8="PTO NB",0,IF(T8="Leave of Absence
NB",0,IF(T8="Available",0,IF(T8="Int. Proj. Available
100%",0,IF(ISNUMBER(FIND("TAG",T8)),0,1)))))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"aledger" wrote in message
...
=IF(T8="PTO NB",0,IF(T8="Leave of Absence
NB",0,IF(T8="Available",0,IF(T8="Int. Proj. Available
100%",0,IF(T8="TAG",0,1)))))

This formula is not returning 0 for finding the word TAG in cell T8. Do I
need to enter a wildcard to get it to find a part of phrase called "TAG".
If
it doesn't find PTO NB, Leave of Absence NB, Available, Int. Proj.
Available
100%, or TAG in cell T8, I want it to return a 1 instead of a 0.

please help.