Fixed function

To use this function, choose Calc > Calculator.

Rounds a number to the specified number of decimals and converts it to text with or without commas.

Syntax

FIXED(number,[decimals],[no_commas])

For number, specify the number or column of numbers you want to round. For decimals, specify the number of places to retain.

If decimals = 1, Minitab rounds to the nearest tenth.
If decimals = 0, Minitab rounds to the nearest integer.
If decimals = -1, Minitab rounds to a multiple of ten.
If you don't enter a second argument, Minitab rounds to 2 decimal places.

Minitab inserts commas to separate some place values (hundreds and thousands, hundred-thousands and millions, and so on) in the converted text. If you don't want the commas to appear, enter a value of 1 for the optional third argument, no_comma. If you want the commas to appear, enter 0 or exclude the third argument entirely.

Examples

Column	Calculator expression	Result
C1 contains 2.354784	FIXED(C1,3)	2.355 (text value)
C2 contains 195833.5	FIXED(C2,−3,1)	196000 (text value)