| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
To understand the problem, we need to know what FIND does. It returns the location number of the first character in the FIND. If it does not find the value, it returns an error, hence the need to verify that it returns a number (with ISNUMBER). Therefore, the formula says that if we have FIND return a number (meaning it found the value) then tell me you found it, if not, tell me you didn't find it. Clearer, now? Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=393921 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
| How to refer to a cell format code? | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| Excel formula for seperating two words in the same cell. | New Users to Excel | |||
Threaded Mode
