Just wondering if anyone can help me with this excel if statement as it doesn't seem to be working (I get an error popup): =IF(L17="charity1","answer1",IF(L17="charity2", "answer2","")) Is the syntax wrong or something?