:Mathematics and trigonometric functions. Use the CEILING function to round up.-Table skills免费ppt模版下载-道格办公

Mathematics and trigonometric functions. Use the CEILING function to round up.

Picture and text skills
Case

Rounds the argument Number upward (in the direction of increasing absolute value) to the nearest multiple of the rounding base .

For example, if you are unwilling to use change like "cents" and the price of the product you want to buy is ￥4.42,you can use the formula =CEILING(4.42,0.1)

Rounds prices up to "corners".

Syntax
CEILING (number, significance)
Number The value to be rounded.
Significance is the multiplier that needs to be rounded.

Description
• If the argument is non-numeric, CEILING returns the #VALUE! error value.
• Press away regardless of number sign Rounding up in the direction of 0. If the number is already a multiple of Significance, no rounding is performed.
• If the Number and Signficance symbols are different, CEILING Returns the error value #Num!.

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/shu-xue-he-san-jiao-han-shu-qiao-yong-CEILING-han-shu-xiang-shang-she-ru.html