SheetFX
≡
<< Go back to all functions

FIXED

The FIXED function in Google Sheets is a powerful tool to format a number with a fixed number of decimal places. It is used for displaying numbers in a specific format, especially when dealing with financial data or presenting rounded values. Take a deep dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: FIXED(number, [number_of_places], [suppress_separator])

Parameters:

  • number: The number you want to format.
  • number_of_places: [Optional] The number of decimal places to display. If omitted, it defaults to 2.
  • suppress_separator: [Optional] A boolean value that determines whether to display a thousands separator. If TRUE, it suppresses the separator. If FALSE or omitted, it displays the separator.

Step-by-Step Tutorial

  1. Using FIXED with default settings:

    • Example: =FIXED(1234.5678)
    • Result: 1,234.57

  2. Using FIXED with a specific number of decimal places:

    • Example: =FIXED(1234.5678, 3)
    • Result: 1,234.568

  3. Using FIXED without a thousands separator:

    • Example: =FIXED(1234.5678, 2, TRUE)
    • Result: 1234.57

Use Cases and Scenarios

  1. Financial Reports: Format monetary values for precise presentation.
  2. Scientific Data: Display experimental measurements with fixed decimal places.
  3. Percentage Calculations: Round percentages with a specific number of decimal places.

Related Functions

  • ROUND: Round a number to a specified number of decimal places.
  • CEILING: Round a number up to the nearest integer or multiple of significance.
  • FLOOR: Round a number down to the nearest integer or multiple of significance.

Related Articles