| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value with using Excel function | New Users to Excel | |||
| Function to look at two cells and return a third | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
| Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Linear Mode
