Skip to content

Categories:

Excel表格向上,中,向下取整函数

数字取整可以用下述函数完成:
四舍五入取整=ROUND(A1,0)
截去小数取整=ROUNDDOWN(A1,0)=FLOOR(A1,1)=TRUNC(A1)
截去小数取整为最接近的偶数=EVEN(A1)
截去小数向上取整数=CEILING(A1,1)
截去小数向下取整=INT(A1)

Posted in 收藏.

Tagged with , .


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

You must be logged in to post a comment.