- Picture and text skills
- Case li>
Rounds the argument Number up (in the direction of increasing absolute value) to the nearest multiple of rounding base .
For example, if you are unwilling to use change like "cents" and the price of the item you want to buy is ¥4.42, you can use the formula =CEILING(4.42,0.1) to round the price up Input is represented by "angle".
Syntax
CEILING (number, significance)
Number The value to be rounded.
Significance is the multiplier that needs to be rounded.
Notes
• If the argument is non-numeric, CEILING returns the #VALUE! error value.
• Round up away from 0 regardless of number sign. If the number is already a multiple of Significance, no rounding is performed.
• If Number and Signficance have different signs, CEILING returns the #Num! error value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-miao-ying-yong-CEILING-han-shu-shi-xian-san-jiao-han-shu-de-xiang-shang-she-ru-ji-qiao.html
评论列表(196条)
测试