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)
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy