MIN函数的使用方法

[[{"txt": "excel\u4e2dmin\u51fd\u6570\u662f\u4e00\u7b80\u5355\u800c\u53c8\u5e38\u7528\u7684\u51fd\u6570\uff0c\u6b64\u51fd\u6570\u8fd4\u56de\u6570\u636e\u6216\u8005\u533a\u57df\u4e2d\u6700\u5c0f\u503c\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "excel\u5de5\u4f5c\u8868"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "min\u51fd\u6570\u7684\u8bed\u6cd5\u5982\u4e0b\uff1a"}, {"img": ["https://exp-picture.cdn.bcebos.com/54a89daee8d7592aebaf47cc9f31dfb6336c6794.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6211\u4eec\u968f\u4fbf\u5217\u4e3e\u4e00\u4e9b\u6570\u636e\uff0c\u5c31\u53ef\u4ee5\u7528min\u51fd\u6570\u7edf\u8ba1\u51fa\u6700\u5c0f\u503c\u3002\u5176\u4e2d\uff0c\u53c2\u6570\u53ef\u4ee5\u662f\u5177\u4f53\u6570\u503c\uff0c\u4e5f\u53ef\u4ee5\u662f\u5355\u5143\u683c\u5f15\u7528\u3002\u5982\u4e0b\u56fe\u6240\u5217\u7684\u6570\u636e\uff0c\u5728C2\u4e2d\u5f55\u5165\u516c\u5f0f \u00a0\u201c=MIN(A1,A2,B1,B2)\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/988e1c532f632385f2764525cce833e038725d94.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u51fd\u6570\u8fd4\u56de-1\uff0c\u5373\u6570\u636e\u4e2d\u6700\u5c0f\u503c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/6002c9d4483104ebe9e7f8bb092b74ee1d324e94.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u66f4\u591a\u7684\u65f6\u5019\uff0c\u6211\u4eec\u4e0d\u4f1a\u6570\u636e\u4e00\u4e2a\u4e00\u4e2a\u7f57\u5217\u51fa\u6765\uff0c\u800c\u662f\u76f4\u63a5\u5f15\u7528\u67d0\u4e2a\u533a\u57df\u6c42\u6700\u5c0f\u503c\u3002\u5982\u56fe\uff0c\u5728C1\u4e2d\u5f55\u5165\u516c\u5f0f=MIN(A1:B6)\uff0cA1\uff1aB6\u8868\u793a\u6211\u4eec\u8981\u6c42\u6700\u5c0f\u503c\u7684\u4e00\u4e2a6\u884c2\u5217\u7684\u4e00\u4e2a\u5355\u5143\u683c\u533a\u57df\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/27725684cde34b2c7aaedccb0d0e7c75e4f44394.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u56de\u8f66\uff0c\u5373\u6c42\u51fa\u6765\u533a\u57df\u5185\u7684\u6700\u5c0f\u503c\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ef4c24ceaad7726b3aa2c253bf0f64781523b994.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u7528\u533a\u57df\u4f5c\u4e3a\u51fd\u6570\u53c2\u6570\u65f6\uff0c\u975e\u6570\u503c\u7684\u90e8\u5206min\u51fd\u6570\u4f1a\u5ffd\u7565\uff0c\u8fd9\u7ed9\u6211\u4eec\u754c\u5b9a\u533a\u57df\u5e26\u6765\u4e86\u5f88\u5927\u7684\u65b9\u4fbf\u3002\u5982\u4e0b\u56fe\uff0c\u533a\u57df\u5185\u6709\u6570\u503c\uff0c\u6709\u6587\u672c\uff0c\u6211\u4eec\u53ef\u4ee5\u76f4\u63a5\u5f55\u5165\u516c\u5f0f=MIN(A1:C5)"}, {"img": ["https://exp-picture.cdn.bcebos.com/2083a5d6e1d06de8db212191ca93cee8b104ac94.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u56de\u8f66\uff0c\u51fd\u6570\u8fd4\u56de\u6700\u5c0f\u503c56"}, {"img": ["https://exp-picture.cdn.bcebos.com/e86ba4b842406afe935456711eee41c1b6279f94.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "min\u51fd\u6570\u53ef\u4ee5\u548c\u5176\u4ed6\u51fd\u6570\u5d4c\u5957\u4e00\u8d77\u4f7f\u7528\uff0c\u5982\u548cAVERAGE\u5d4c\u5957\u6c42\u5b66\u79d1\u6210\u7ee9\u5e73\u5747\u5206\u7684\u6700\u4f4e\u503c\u3002\u5728D2\u4e2d\u5f55\u5165\u516c\u5f0f=MIN(AVERAGE(B2:B6),AVERAGE(C2:C6))"}, {"img": ["https://exp-picture.cdn.bcebos.com/91091efc77f7980e0160e4c5d4db3620b83a9194.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u56de\u8f66\uff0c\u51fd\u6570\u8fd4\u56de67.2\uff0c\u5373\u5b66\u79d1\u6700\u4f4e\u5e73\u5747\u5206\u4e3a67.2\u5206\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/444696013870d54157cc01bc2e0f94fc518c8094.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u5982\u679c\u6b64\u7ecf\u9a8c\u5bf9\u60a8\u6709\u7528\uff0c\u8bf7\u6295\u6211\u4e00\u7968\uff0c\u8c22\u8c22\uff01\uff01"}]]