| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find formula and return value
Hi i am using the following formula to find text in a cell
=IF(ISNUMBER(FIND("Super",B96)),"OK", "Not OK") and return a value. i have adapted the formula for another spreadsheet and simply added more values to check, i.e. =IF(ISNUMBER(FIND("Super""Account""Business:,B96)) ,"OK", "Not OK") but it doesnt seem to work. where i can see the value in the cell it is not returning ok instead of not ok. is there a limit to the number of values i can search and if so why doesnt it say as an error? what am i missing? Thanks very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| Date formula...help with return on formula | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions | |||
Threaded Mode
