Just to check you're using the character [ " ] right and not just the [ ' ] pressed twice? " '' because they look similar (joking)
But seriously the quotation marks denote text in excel so anything placed between them will be identified as text, a double quotation mark [ "" ] is what I used to denote a blank cell. IF functions are not case sensitive but they will get upset if the there is a space either side of the characters. I tend to use the =SEARCH("a",b,0) function first and then =IF(x>0,y,z) to overcome this, it can also overcome formatting errors, the IF function doesn't work well when you have numbers stored as text =IF(x="123",b,c) is totally different to =IF(x=123,b,c) because one is looking for a number, the other is looking for text.
Tobi_96 reacted to Jackalovski in Excel if-function with text
