Basic Functions : FIXED

In OpenOffice Calc, the FIXED function returns a text representation of a number rounded to a specified number of decimal places.


The arguments to the function are :

FIXED(number, decimal_places, no_commas)
where

  • number… is the number to round.
  • decimal_places is the number of decimal places to display in the result.
  • no_commas If this parameter is set to TRUE, the result will not display commas. If it is set to FALSE, it will display commas in the result.

We see a few examples of the FIXED function below.

fixed.jpg

Leave a Reply