need IF function to return 0 if it finds a one out of three words

=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.

=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" <aledger@discussions.microsoft.com> wrote in message
news:7A5CB77D-A0C4-4B99-9892-1DBC3FA50172@microsoft.com...
> =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.

Hi
Here is another option as well.

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

HTH
Michael

"aledger" wrote:

> =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.

Oops......
Sorry, I cut and pasted the wrong formula. Try this one

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

HTH
Michael

"aledger" wrote:

> =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.