如何在Excel中取整数值为最接近于5的整数倍

如何在Excel中取整数值为最接近于5的整数倍

回复
  • 宋梓萌用户
    [[{"txt": "\u5728Excel\u4e2d\uff0c\u5bf9\u6570\u636e\u7684\u5904\u7406\u975e\u5e38\u65b9\u4fbf\uff0c\u6bd4\u5982\u6211\u4eec\u53ef\u4ee5\u5bf9\u6570\u636e\u53d6\u6574\u4e3a\u6700\u63a5\u8fd1\u4e8e5\u7684\u6574\u6570\u500d\u3002\u90a3\u4e48\uff0c\u5982\u4f55\u5728Excel\u4e2d\u53d6\u6574\u6570\u503c\u4e3a\u6700\u63a5\u8fd1\u4e8e5\u7684\u6574\u6570\u500d\u5462\uff1f\u672c\u6587\u5e26\u5927\u5bb6\u4e86\u89e3\u4e00\u4e0b\uff0c\u4e00\u8d77\u6765\u770b\u770b\u5427~"}, {"img": ["https://exp-picture.cdn.bcebos.com/059057299a8839133f172d5d26bcbe2f46707c4a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Excel\u7248\u672c\uff1aMicrosoft Office \u4e13\u4e1a\u589e\u5f3a\u7248 2016 "}, {"txt": "\u7535\u8111\u7cfb\u7edf\uff1awindows 10"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "1.\u6253\u5f00Excel\u5de5\u4f5c\u8868\u3002\u5047\u8bbe\u6211\u4eec\u6709\u4e00\u4e2a\u6570\u636e\u8868."}, {"img": ["https://exp-picture.cdn.bcebos.com/edafb3bcbe2f47709aea1e696f3b3b860321794a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "2.\u70b9\u51fbfx\u63d2\u5165\u51fd\u6570\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e57a258602214f5771a49208732064fb970b734a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "3.\u641c\u7d22\u627e\u5230\u51fd\u6570CEILING\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/92174dbbf82064fb70f9f0928e6104a354e96f4a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "4.\u8bbe\u7f6e\u53c2\u6570Number\u503c\u4e3a\u3010A2\u3011\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/30601b6104a355e9685c2964d22ae3efe178684a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "5.\u8bbe\u7f6e\u53c2\u6570significance\u503c\u4e3a\u30105\u3011\u3002\u8fd9\u4e2a\u503c\u662f\u51fd\u6570\u7684\u57fa\u6570\uff0c\u8868\u793a\u63095\u7684\u500d\u6570\u53d6\u6574\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/586bfdefe07814312e44f3dfdc6699cf0353624a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "6.\u786e\u5b9a\u540e\u4e0b\u62c9\u516c\u5f0f\u5b8c\u6210\u4e86\u53d6\u6574\u6570\u503c\u4e3a\u6700\u63a5\u8fd1\u4e8e5\u7684\u6574\u6570\u500d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/def72c6c576699cff7a1eed0a885e036e3915e4a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "END"}], [{"txt": ["\u603b\u7ed3\uff1a"]}, {"txt": "1.\u6253\u5f00Excel\u5de5\u4f5c\u8868\u30022.\u70b9\u51fbfx\u63d2\u5165\u51fd\u6570\u30023.\u641c\u7d22\u627e\u5230\u51fd\u6570CEILING\u30024.\u8bbe\u7f6e\u53c2\u6570Number\u503c\u4e3a\u3010A2\u3011\u30025.\u8bbe\u7f6e\u53c2\u6570significance\u503c\u4e3a\u30105\u3011\u30026.\u786e\u5b9a\u540e\u4e0b\u62c9\u516c\u5f0f\u5b8c\u6210\u4e86\u53d6\u6574\u6570\u503c\u4e3a\u6700\u63a5\u8fd1\u4e8e5\u7684\u6574\u6570\u500d\u3002"}, {"txt": "END"}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "Tips:\u6ce8\u610f\uff0c\u51fd\u6570CEILING\u662f\u6570\u503c\u5411\u4e0a\u53d6\u820d\u3002"}]]
    2024-11-22
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请