Rounds a number to a specified number of decimals and formats it as text with or without commas.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
FIXED(number, [decimals], [no_commas])The FIXED function converts a numeric value into a text string using a fixed number of decimals. It allows you to control whether thousands separators are included in the final output.
=FIXED(1234.567, 1)결과: "1,234.6"
Rounds the number to one decimal place and includes the comma separator.
=FIXED(1234.567, 0, TRUE)결과: "1235"
Rounds to the nearest whole number and removes the comma separator.
It returns a text string, meaning you cannot perform mathematical calculations on the result directly.