IF statements

[Guest]

Hello:

I don't understand why I can't get this IF statement to work. In column E,
I have among other things cells that contain the phrase "CREDIT CARD".

In column C, I want the cells to say "VISA" for cells in E that say "CREDIT
CARD".

So, here's my statement:
=IF($E7="MBI CREDIT CARD","VISA","")

Why isn't this working? Instead of showing "VISA", it's blank! That's not
correct.

Thanks!

childofthe1980s

 

[Guest]

Just a WAG but try

=IF(trim($E7)="MBI CREDIT CARD","VISA","")

Assuming that the spelling a capitalization is correct...

 

[Karthik Bhat - Bangalore]

Hi

This should work

=IF(ISERROR(FIND("CREDIT CARD",UPPER($E7),1)),"","VISA")