To use this function, choose .

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

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.

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) |