0

I don't get it how to use multiple conditions in the following case...

IF(COUNTIF(name,name)>1 AND(ISBLANK(meaning)),"x", "")

What this should do is compare the cells in column A (name) for duplicates and also check if column G (meaning) is blank. But it tells me syntax error. Where and how do I use the AND?

0

Figured it out! AND cannot be used since it's a function itself, instead IF needs to be nested, like this...

IF(COUNTIF(name,name)>1,IF(ISBLANK(meaning),"X",""),"")
  • Glad you found a solution! You can mark your own answer as answered so others with the same question can find it. – bjbk Jul 30 '15 at 18:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .