round函数（让excel自动取舍小数点，这三个函数都能轻松搞定）
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1416119137658217"
crossorigin="anonymous"></script>
<ins class="adsbygoogle"
style="display:block"
data-ad-format="fluid"
data-ad-layout-key="-ef+6k-30-ac+ty"
data-ad-client="ca-pub-1416119137658217"
data-ad-slot="9398439682"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<div class="show-monitor" style="box-sizing: border-box; margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: system-ui, -apple-system, "Segoe UI", Rototo, Helvetica, Arial, sans-serif; font-size: medium; white-space: normal; background-color: rgb(255, 255, 255);"><div class="article-content" style="box-sizing: border-box; margin: 0px; padding: 0px;"><article class="syl-article-base tt-article-content syl-page-article syl-device-pc" style="box-sizing: border-box; padding: 0px; text-align: justify; overflow-wrap: break-word; word-break: break-word; overflow: hidden; hyphens: auto; color: rgb(34, 34, 34); font-family: "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", "Helvetica Neue", Arial, sans-serif; line-height: 1.667; font-size: 18px; margin-bottom: 20px;"><p style="box-sizing: border-box; margin-bottom: 20px; padding: 0px; border: 0px; margin-top: 0px !important;"><span style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-size: 0.833em;">设置小数点的位数，一般大家都习惯于利用单元格来设置方便快捷键，但是他的局限性也是比较大的，就是仅仅只能做四舍五入，无法进行向上或者向下取舍，这个时候为我们就需要使用函数来解决，今天跟大家分享三个关于小数点位数的取舍函数，它们的操作也都非常的简单，下面就让我来一起学习下吧</span></p><div class="tt-community-card" data-content="{"community_id":"6797636636239725064","media_id":1615002698472462,"media_name":"Excel从零到一","title":"excel技巧","square_cover":"pgc-image/7ab51266169f42f1bee73e4fa0b84486","price":1,"renew_price":0.5,"share_price":0,"member_count":584,"period":3,"allow_bind":1}" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px;"><div class="community-placeholder" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px;">（此处已添加圈子卡片，请到今日头条客户端查看）</br>微信搜索公众号【深圳家】或者直接搜索【i-shenzhen】，获取更多信息
页:
[1]