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

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

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)