Help Center

FIXED

Formula Explanation

Rounds a number to a specified number of decimal places, formats the number using a period and comma as decimal separators, and returns the result as text.

Formula Syntax

Enter in the result column: FIXED(number / column number, [decimal places], [logical value])

The FIXED function syntax has the following arguments:

  • Number (required): The number to be rounded and converted to text.

  • Decimal places (optional): The number of decimal places to the left (negative) or right (positive) of the decimal point.

  • Logical value (optional): A logical value. If TRUE, FIXED excludes commas from the returned text.

Usage Example

Round the values in column CV2 to 1 decimal place, exclude commas, and write the results into column CV3.

CV3 = FIXED(CV2, 1, true)

fixed_r

Round the numbers in column CV2 to the first decimal place to the left of the decimal point, exclude commas, and write the results into column CV4

CV4 = FIXED(CV2, -1, true)

fixed_l

Last Updated: