| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Statement - Excel Version 2002
Can you please give me an IF statement for following:
If (Col A1 is equal to LIBOR (Need wildcard for LIBOR that will pick up LIBOR1 or LIBOR3 or LIBOR6), Then Column B1- Column C1, Else 0) Column A LIBOR1 Fixed LIBOR3 LIBOR6 -- Thanks! biz |
|
#2
|
|||
|
|||
|
biz
Entered in D1 =IF(ISNUMBER(FIND("LIBOR",A1)),B1-C1,0) No wildcard necessary. Gord Dibben Excel MVP On Mon, 26 Sep 2005 14:39:03 -0700, biz wrote: Can you please give me an IF statement for following: If (Col A1 is equal to LIBOR (Need wildcard for LIBOR that will pick up LIBOR1 or LIBOR3 or LIBOR6), Then Column B1- Column C1, Else 0) Column A LIBOR1 Fixed LIBOR3 LIBOR6 |
|
#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) |
| Reply |
| 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) | |||
Linear Mode
