I have many problems at the moment with IF statements. Why is it that sometimes (see attached sample) I just get the text I entered in the formula box and not the formula working as it should? That's my first question. There will be others if I don't give up beforehand with Excel's weirdness. See attached example.