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

Mathematics and trigonometric functions. Use the FLOOR function skillfully to round down.

  • Picture and text skills
  • Case

Rounds the argument Number down in the direction of decreasing absolute value to equal the nearest multiple of Significance.

Grammar

FLOOR(number,significance)

Number The value to be rounded.

Significance cardinality.


Description

• If any argument is nonnumeric, Floor returns the #VALUE! error value.

• If Number and Significance have opposite signs, function Floor returns the #Num! error value.

• Regardless of the sign of the Number, the absolute value of the argument is reduced when rounded.

If Number is exactly a multiple of Significance, no rounding is required.

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-FLOOR-han-shu-xiang-xia-she-ru.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion