Excel随机函数的用法详解

[[{"txt": "\u76f8\u4fe1\u5927\u5bb6\u5728\u505aexcel\u8868\u683c\u7684\u65f6\u5019\u7ecf\u5e38\u6027\u7684\u4f1a\u7528\u5230\u6bd4\u8f83\u591a\u7684\u968f\u673a\u51fd\u6570\uff0c\u6bd4\u5982\u6b64\u5217\u5355\u5143\u683c\u53ea\u9700\u8981\u586b\u51651-10\u7684\u6574\u6570\uff0c\u6216\u80051-100\u7684\u6574\u6570\u7b49\u7b49\u7c7b\u4f3c\u7684\u95ee\u9898\uff0c\u4e0b\u9762\u5c31\u4e3a\u5927\u5bb6\u4ecb\u7ecdExcel\u968f\u673a\u51fd\u6570\u7684\u7528\u6cd5\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": " Excel2003"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "EXCEL\u968f\u673a\u6570\u6307\u968f\u673a\u751f\u6210\u6ca1\u6709\u89c4\u5f8b\u7684\u6570\u503c\uff0c\u6709\u968f\u673a\u5c0f\u6570\u548c\u968f\u673a\u6574\u6570\u3002RAND\u51fd\u6570\u7528\u4e8e\u751f\u6210\u968f\u673a\u5c0f\u6570\u3002RANDBETWEEN\u51fd\u6570\u7528\u4e8e\u751f\u6210\u968f\u673a\u6574\u6570\u3002\u8fd8\u53ef\u4ee5\u751f\u6210\u65f6\u95f4\u968f\u673a\u6570\u3002RANE\u51fd\u6570\u53ef\u4ee5\u751f\u62100-1\u4e4b\u95f4\u7684\u968f\u673a\u5c0f\u6570\uff0c\u5c0f\u6570\u4f4d\u6700\u591a15\u4f4d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/50a010f85856d53d3f8b6b5c47d2bb665059ca04.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "RANDBETWEEN\u51fd\u6570\u7528\u4e8e\u751f\u6210\u968f\u673a\u6574\u6570\uff0c\u5141\u8bb8\u4ea7\u751f\u8d1f\u6574\u6570\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/0fb94656d53da82440467f67306651598440cb04.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "RAND\u51fd\u6570\u5e94\u7528\uff1b\u56e0RAND\u51fd\u6570\u6ca1\u6309\u4e00\u6b21DELETE\u6216F9\u5c31\u4f1a\u91cd\u65b0\u8ba1\u7b97\u4e00\u6b21\uff0c\u6240\u4ee5\u8981\u60f3\u4fdd\u5b58\u6570\u503c\u5c31\u9700\u8981\u590d\u5236\u5728\u9009\u62e9\u6027\u7c98\u8d34\u6570\u503c\u3002\u4ea7\u751f\u968f\u673a\u5c0f\u6570\u5728\u5355\u5143\u683c\u5185\u8f93\u5165=RADN\uff08\uff09\u5c06\u4f1a\u4ea7\u751f\u968f\u673a\u5c0f\u6570\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/5917cb3da824d8e9557d08d3da598540112ac804.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/d47cb624d8e9ccd221c9e2ec0e40102a05e2c904.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "RAND\u51fd\u6570\u751f\u6210\u968f\u673a\u6570\u5e76\u9650\u5236\u5176\u5c0f\u6570\u4f4d\u6570\uff1a\u6211\u95e8\u9700\u8981\u7528\u5230ROUND\u51fd\u6570\uff0c\u5e94\u4e3aRAND\u51fd\u6570\u4ea7\u751f0-1\u4e4b\u95f4\u7684\u51fd\u6570\u6211\u95e8\u53ef\u4ee5\u5c06\u5b83\u4e58\u4ee5\u6216\u52a0\u4e0a\u5176\u4ed6\u6570\u503c\u3002\u4f8b\u5982:1\u3001=RAND()*1002\u3001=ROUND(RAND()*100,1)\u8fd8\u53ef\u4ee5\u642d\u914d\u5176\u4ed6\u51fd\u6570\u5982CEILING\u51fd\u6570\uff0cCEILING\u51fd\u6570\u8868\u8ff0\u6309\u71670.4\u500d\u8fdb\u4f4d\u4f8b\u5982\uff1b=CEILING(ROUND(RAND()*100,3),0.4)"}, {"img": ["https://exp-picture.cdn.bcebos.com/a965c6e9ccd2bb66caf636f59b2a04e23fa2c604.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/8db0c6a726334884d353f899ddee7b7f870e4505.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/d9e638334884cde3549ce55bf07f860e7d754205.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "RANDBETWEEN\u51fd\u6570\uff0c\u5b83\u6709\u4e24\u4e2a\u5fc5\u987b\u6761\u4ef6\u5206\u522b\u4e3a\u4e0a\u9650\u548c\u4e0b\u9650\u3002\u8868\u8fbe\u5f0f\u4e3a=RANDBETWEEN(bottom\uff0ctop)"}, {"img": ["https://exp-picture.cdn.bcebos.com/27725684cde34b2c765ec8ca0d0e7c75e4f44305.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u4f8b\u5982;=INDEX({\"\u5f20\",\"\u738b\",\"\u674e\",\"\u8d75\"},RANDBETWEEN(1,4))\u8868\u793a\u5728\u8868\u683c\u4e2d\u968f\u673a\u751f\u6210\u5f20\u3001\u738b\u3001\u674e\u3001\u8d75\u3002INDEX \u51fd\u6570\u8fd4\u56de\u8868\u683c\u6216\u533a\u57df\u4e2d\u7684\u503c\u6216\u503c\u7684\u5f15\u7528"}, {"img": ["https://exp-picture.cdn.bcebos.com/49c5d3e34b2c56ee5acf35bbf775e5f4fdf54005.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fdb\u4e00\u6b65\u5e94\u7528\u968f\u673a\u51fd\u6570\u751f\u6210\u65f6\u95f4\u51fd\u6570\u793a\u4f8b\uff1a\u5c31\u8981\u7528\u5230TEXT\u51fd\u6570\u3002TEXT\u51fd\u6570\u7b80\u4ecb\uff1b\u5982\u679c\u60a8\u60f3\u8981\u5408\u5e76\u6587\u672c\u548c\u6570\u5b57\uff0c\u5982\u65e5\u671f\uff0c\u53ef\u8bfb\u683c\u5f0f\u5230\u4f7f\u7528TEXT\u51fd\u6570\u3002=TEXT(\"0:19\"+RAND()*\"0:03\",\"H:MM\")\u8868\u8ff00\uff1a19\u52a00-2\u5206\u949f\u4ee5H\uff1aMM\u683c\u5f0f\u663e\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/cca2552c56ee7b7fa4becfc06ef4fcf5ef0d4105.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u51fd\u6570\u5e94\u7528\u8981\u7075\u6d3b\uff0c\u7ec4\u5408\u4f7f\u7528\u6548\u679c\u66f4\u597d\u3002"}]]