Thread: IF statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childothe1980s childothe1980s is offline
external usenet poster
 
Posts: 23
Default IF statements

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