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?
Best Answer
Figured it out! AND cannot be used since it's a function itself, instead IF needs to be nested, like this...