Apple Numbers using AND in formula to find dupes I don't get it how to use multiple conditions in the following case...

IF(COUNTIF(name,name)&gt;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?
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)&gt;1,IF(ISBLANK(meaning),"X",""),"")