Excel表格中怎么判断单元格是否满足条件

[[{"txt": "\u600e\u6837\u5229\u7528\u51fd\u6570\u6765\u5224\u65ad\u5355\u5143\u683c\u662f\u5426\u6ee1\u8db3\u6761\u4ef6\uff0c\u4e0b\u9762\u5c0f\u7f16\u5c31\u6765\u4ecb\u7ecd"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u4e0b\u9762\u662f\u793a\u4f8b\u8868\u683c\uff08\u5982\u56fe\uff09\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/bfa52adaf05e4a2300df47a91dd818196020e206.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd9\u91cc\u9700\u8981\u5230\u51fd\u6570IF\u548c\u51fd\u6570AND\uff1aIF\u51fd\u6570\u7684\u4f5c\u7528\u662f\u5224\u65ad\u67d0\u4e2a\u6761\u4ef6\u662f\u5426\u7b26\u5408\u6761\u4ef6\uff0c\u7b26\u5408\u8fd4\u56de\u4e00\u4e2a\u503c\uff0c\u4e0d\u7b26\u5408\u8fd4\u56de\u53e6\u4e00\u4e2a\u503c\uff08\u5982\u56fe\uff09\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/983aa5f4da5872da59e7d8bb0056ad042f68d406.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "AND\u51fd\u6570\u7684\u4f5c\u7528\u662f\u68c0\u67e5\u6240\u6709\u53c2\u6570\u662f\u5426\u90fd\u4e3aTRUE\uff0c\u90fd\u4e3aTRUE,\u5219\u8fd4\u56deTRUE\uff08\u5982\u56fe\uff09\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/5917cb3da824d8e95f7c02d2da598540112ac806.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728D1\u5355\u5143\u683c\u8f93\u5165\u516c\u5f0f\u201c=IF(AND(A1=\"\u662f\",B1=\"\u662f\",C1=\"\u5426\"),\"\u6ee1\u8db3\",\"\u4e0d\u6ee1\u8db3\")\u201d\uff08\u5982\u56fe\uff09\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/a13bbe10bc33ec38ab15a05b295f0c14c37b3c07.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u70b9\u51fbenter\u952e\u540e\u5373\u53ef\u8fd4\u56de\u503c\uff08\u5982\u56fe\uff09\uff1b"}, {"img": ["https://exp-picture.cdn.bcebos.com/d3c39889a146b7b14657c609c77c34b33d413507.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u63a5\u4e0b\u6765\u5411\u4e0b\u586b\u5145\u5373\u53ef\u8fd4\u56de\u6240\u6709\u5224\u65ad\u503c\uff08\u5982\u56fe\uff09\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e076d77622bc7dc57bc992eb5e460596b9142907.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u6b64\u7ecf\u9a8c\u4e43\u5b9e\u9645\u64cd\u4f5c\u6240\u5f97\uff0c\u5982\u6709\u5e2e\u52a9\u8bf7\u70b9\u8d5e\u6216\u6295\u7968\uff0c\u8c22\u8c22\uff01\uff01"}, {"txt": "\u540c\u6837\u4e5f\u6b22\u8fce\u5c0f\u4f19\u4f34\u4eec\u7684\u5173\u6ce8\uff0c\u8fd9\u4e2a\u662f\u7ed9\u5c0f\u7f16\u6700\u5927\u7684\u9f13\u52b1\uff01\uff01"}]]