Excel - The FIXED function

January 2017



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

Related


Published by aakai1056. Latest update on November 15, 2011 at 11:12 AM by aakai1056.
This document, titled "Excel - The FIXED function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).