如何在excel中利用if函数提高效率

[[{"txt": "\u5728excel\u4e2d\u51fd\u6570\u7684\u5229\u7528\u53ef\u4ee5\u5927\u5927\u63d0\u9ad8\u6548\u7387\uff0cif\u51fd\u6570\u662f\u7ecf\u5e38\u4f7f\u7528\u7684\u51fd\u6570\uff0c\u672c\u7bc7\u5c31\u6765\u7528\u4e00\u4e2a\u5c0f\u5c0f\u7684\u4f8b\u5b50\u6765\u548c\u5927\u5bb6\u4e00\u8d77\u5b66\u4e60\u5982\u4f55\u5229\u7528if\u51fd\u6570\u63d0\u9ad8\u6548\u7387\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u7535\u8111\u3001excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5982\u56fe\u6240\u793a\uff0c\u8868\u683c\u4e2d\u7eff\u8272\u7684\u90e8\u5206\uff0c\u8981\u6c42\u5e74\u9f84\u5927\u4e8e18\u663e\u793a\u201c\u7b26\u5408\u201d\uff0c\u5c0f\u4e8e18\u5c81\u663e\u793a\u201c\u4e0d\u7b26\u5408\u201d\uff0c\u5982\u679c\u4eba\u5de5\u5224\u65ad\uff0c\u6570\u503c\u5c11\u7684\u65f6\u5019\u8fd8\u597d\uff0c\u5982\u679c\u591a\u4e86\u5c31\u9700\u8981\u7528if\u51fd\u6570\u6765\u63d0\u9ad8\u6548\u7387\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/32fe25ef354f50b8306e5068dc4afa32929c18e4.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u5355\u5143\u683c\u5185\u8f93\u5165=IF(D5>18,\"\u7b26\u5408\",\"\u4e0d\u7b26\u5408\")"}, {"img": ["https://exp-picture.cdn.bcebos.com/51f9aa3ea8db574a7d626b2fa7f7dfb2dd1917e4.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6572\u51fb\u56de\u8f66\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/def3c219ce2c5b1b908e0c6f2b39131fcfec0ee4.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u5c06\u9f20\u6807\u5149\u6807\u79fb\u52a8\u5230\u7b2c\u4e00\u4e2a\u5355\u5143\u683c\u53f3\u4e0b\u89d2\uff0c\u51fa\u73b0\u9ed1\u8272\u5c0f\u5341\u5b57\u7684\u65f6\u5019\u5f80\u4e0b\u62d6\u62fd\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/1f9feadca039131f5cbc2b6ae275f2c4ed990ae4.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8c03\u6574\u4e00\u4e0b\u5355\u5143\u683c\u7684\u683c\u5f0f\uff0c\u9009\u62e9\u5c45\u4e2d\uff0c\u5c31\u641e\u5b9a\u4e86\uff0c\u662f\u4e0d\u662f\u5feb\u591a\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/cfadcdd96975f2c47ac9a1f08f0148fe1f4206e4.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]