| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Gord Dibben wrote...
Entered in D1 =IF(ISNUMBER(FIND("LIBOR",A1)),B1-C1,0) No wildcard necessary. .... Perhaps not, but only at the cost of 2 function calls besides the IF call. =IF(COUNTIF(A1,"LIBOR?"),B1-C1,0) or even =COUNTIF(A1,"LIBOR?")*(B1-C1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
| Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
| Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Threaded Mode
