Excel如何用if函数为数据分类

[[{"txt": "\u8d22\u52a1\u6709\u65f6\u4f1a\u6d89\u53ca\u5230\u4e00\u4e9b\u6742\u9879\u7684\u8ba1\u7b97\u548c\u5f52\u7c7b\uff0c\u5982\u4f55\u5feb\u901f\u7684\u5206\u51fa\u51fd\u6570\u7684\u5404\u79cd\u7c7b\u522b\u5462\uff1f\u4e0b\u9762\u5c0f\u7f16\u4e3a\u5927\u5bb6\u5206\u4eabexcel\u7528if\u51fd\u6570\u4e3a\u6570\u636e\u5206\u7c7b\u7684\u65b9\u6cd5\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u6f14\u793a\u8f6f\u4ef6\uff1aexcel 2016"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u6253\u5f00excel\u8868\u683c\uff0c\u9009\u62e9\u5206\u7c7b\u7684\u754c\u9650\uff0c\u6dfb\u52a0\u8f85\u52a9\u5217\u3002\u6bd4\u5982\u4ee5\u4e0b\u6309\u7167\u5927\u5c0f\u8fd4\u6d9b\u6765\u5206\u7c7b\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/05e24be983aee8d7906c065d6b781431deb66699.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u4e0b\u56fe\u516c\u5f0f\u53ef\u4ee5\u770b\u51fa\u8d85\u51fa\u90e8\u5206\u7684\u6bd4\u4f8b\u662f\u5426\u5927\u4e8e5%\u3002\u8054\u88ad"}, {"img": ["https://exp-picture.cdn.bcebos.com/586bfdefe078143112f0d7dedc6699cf03536299.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u4e0b\u56fe\u516c\u5f0f\uff0c\u786e\u8ba4\u6700\u7ec8\u62a5\u9500\u6c7d\u9500\u77a7\u91d1\u989d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e177fc9147e833e0e134d8b130ea3e8631485999.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u65b0\u5efa\u5217\uff0c\u8ba1\u7b97\u51fa\u8d85\u51fa\u90e8\u5206\u7684\u91d1\u989d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/1570c1b6326c57664989e7e1a4632385e1366199.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7528\u6570\u636e\u900f\u89c6\u8868\u6765\u7edf\u8ba1\u6570\u636e\uff0c\u5206\u7c7b\u7edf\u8ba1\u6570\u91cf\u548c\u6c42\u548c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/988e1c532f63238534700723cce833e038725d99.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7edf\u8ba1\u8d85\u51fa\u548c\u672a\u8d85\u51fa\u7533\u8bf7\u989d\u7684\u5355\u636e\u6570\u91cf\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/562787cf02532f63f0c30584699147e832e05c99.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u53ef\u4ee5\u901a\u8fc7\u7ec4\u5408\uff0c\u5c06\u65e5\u671f\u5206\u7ec4\u5230\u5468\uff0c\u64cd\u4f5c\u6b65\u9aa4\u5982\u4e0b\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/031231632385e03637d7a25ab8e039723c035a99.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6700\u540e\uff0c\u7b97\u51fa\u603b\u91d1\u989d\u548c\u7533\u8bf7\u91d1\u989d\u7684\u5dee\u6570\uff0c\u663e\u793a\u6548\u679c\u5982\u4e0b\u56fe\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/2e223d85e036e29191aed652b2723d03baea5b99.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]