I have oftentime used If statement in the past, but always with numerical data. Now I have a statement I'm trying to write, which will refer a text cell, and it isn't working right.
If I have the word "solo" in a cell, for instance. In another cell, I can have the formula =IF(D1="solo",0,1) and it will properly return a 0 for the word Solo. But I want it to return a true value even if the cell doesn't just say "Solo" -- but says "Solo 1200" or "Solo 3900", etc etc. I have tried an asteriks after the word Solo, and that just keeps it from functioning entirely. So how do I tell it to return a true value if the letters "solo" are ANYWHERE in the cell? THanks!