IF Statement - Excel Version 2002

B

biz

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
 
G

Gord Dibben

biz

Entered in D1

=IF(ISNUMBER(FIND("LIBOR",A1)),B1-C1,0)

No wildcard necessary.


Gord Dibben Excel MVP
 
H

Harlan Grove

Gord Dibben wrote...
Entered in D1

=IF(ISNUMBER(FIND("LIBOR",A1)),B1-C1,0)

No wildcard necessary.
Click to expand...
....

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)
 
Top