Excel - The FIXED function

Ask a question


Description


This function will return as value, a text representation of number rounded to a specific decimal places.

Syntax


Fixed(number,decimal_places,no_commas)
  • number: represents the number to be rounded
  • decimal_places: as the name suggests, the decimal places
  • no_commas: can have one of these status:
    • TRUE: commas displayed in result
    • FAlSE: commas not displayed

Excel - The TRIM function
Excel - The MROUND function