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

G

Guest

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

Bob Phillips

=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)
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF - Nesting... almost got it - need a bit of help 1
If Function returning 0 instead of cell value 4
Return 0 if cell has data, of copy if it doesn't 2
Need to average data if in cells, but ignore blank cells. 4
If function across sheets prints value of cell 4
Concatenate results of scores and return sum of percentages 3
If function returns #REF!, want it to return 0 2
Excel If statement that is supposed to return a "" instead returns a 0 1

Top