| 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. |
| 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 | |||
Threaded Mode
