:"Fun with Excel: FIXED function accurately controls the number of decimal places"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Fun with Excel: FIXED function accurately controls the number of decimal places"

"Fun with Excel: FIXED function accurately controls the number of decimal places"

Author: daogeziyuan • • Table skills • Views 666
```html
  • Picture and text skills
  • Case

Rounds a number to the specified number of decimal places, formats the number in decimal format using periods and commas, and returns the result as text.

SyntaxFIXED(number,decimals,no_commas)

Number The number to be rounded and converted to a text string.

Decimals A numeric value that specifies the number of decimal places to the right of the decimal point.

No_commas A logical value that, if TRUE, prevents FIXED from including commas in the returned text.

If Decimals is negative, the number argument is rounded to the left of the decimal point.

If the decimal is omitted, it is assumed to be 2.

If its value is FALSE or omitted, the returned text contains commas as usual.

The main difference between this function and using the Cells command on the Format menu to format cells that contain numbers is that the FIXED function converts its results to text, whereas the results of the Cells command's formatting are still numbers.

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/wan-zhuan-Excel-FIXED-han-shu-jing-que-kong-zhi-xiao-shu-wei-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu slam dunk Columnist
48 196
single-end

Related Suggestion