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
|