FIXEDfunction 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
- Examples of using
FIXEDformula not working?
- Similar formulas to
FIXED formula with the syntax shown below, it has 1 required parameter and 2 optional 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.
ExamplesHere are a few example use cases that explain how to use the
FIXEDformula in Google Sheets.
Formatting monetary values
FIXED function can be used to format monetary values with a specified number of decimal places, making them easier to read and compare.
FIXED function can also be used to display percentages with a specified number of decimal places, making them easier to interpret.
Formatting numeric codes
FIXED function can be used to format numeric codes, such as product IDs or phone numbers, with a specified number of decimal places.
FIXEDnot working? Here are some common mistakes people make when using the
FIXEDGoogle 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
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
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:
ROUNDformula 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
placesparameter is not specified, the formula rounds to the nearest integer.
TRUNCformula 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.
CEILINGfunction 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.
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.
You can learn more about the
FIXED Google Sheets function on Google Support.