How to use FIXED Google Sheets formula?

The syntax for the FIXED formula is =FIXED(number, [number_of_places], [suppress_separator]), it has 1 required parameter and 2 optional parameters.

Why is FIXED Google Sheets formula not working?

One common reason the FIXED formula may not be working is due to forgetting to specify the number of decimal places. If you omit the <code>number_of_places</code> parameter, the <code>FIXED</code> formula will use a default value of 2, which may not be what you want. Be sure to specify the number of decimal places you require.

FIXED

The FIXED function formats a number as text with a specified number of digits after the decimal point. It is commonly used to display monetary values or percentages. The function returns the formatted number as a text string.

How to use FIXED formula?
Examples of using FIXED formula
FIXED formula not working?
Similar formulas to FIXED

Usage

Use the FIXED formula with the syntax shown below, it has 1 required parameter and 2 optional parameters:

=FIXED(number, [number_of_places], [suppress_separator])

Parameters:

number (required):
The number to be formatted as text.
number_of_places (optional):
The number of decimal places to display. If omitted, defaults to 2.
suppress_separator (optional):
A boolean value that determines whether to use a thousands separator. If true, the separator is not used. If omitted, defaults to false.

Examples

Here are a few example use cases that explain how to use the FIXED formula in Google Sheets.

Formatting monetary values

The FIXED function can be used to format monetary values with a specified number of decimal places, making them easier to read and compare.

Displaying percentages

The FIXED function can also be used to display percentages with a specified number of decimal places, making them easier to interpret.

Formatting numeric codes

The FIXED function can be used to format numeric codes, such as product IDs or phone numbers, with a specified number of decimal places.

Common Mistakes

FIXED not working? Here are some common mistakes people make when using the FIXED Google Sheets Formula:

Forgetting to specify the number of decimal places

If you omit the number_of_places parameter, the FIXED formula will use a default value of 2, which may not be what you want. Be sure to specify the number of decimal places you require.

Using the formula with non-numeric values

The FIXED formula can only be used with numeric values. If you try to use it with text or other non-numeric data, you will get an error message.

Forgetting to include the number parameter

The FIXED formula requires a number parameter to be specified. If you forget to include this parameter, you will get an error message.

The following functions are similar to FIXED or are often used with it in a formula:

ROUND
The ROUND formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the places parameter is not specified, the formula rounds to the nearest integer.
TRUNC
The TRUNC formula returns a number truncated to a specific number of decimal places. It is commonly used to remove decimal places from a number without rounding. This formula is often used in financial calculations and data analysis where exact values are important.
CEILING
The CEILING function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments.
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

Learn More

You can learn more about the FIXED Google Sheets function on Google Support.