Skip to main content

FIXED

Definition

Formats a number with a fixed number of decimal places.

Sample Usage

FIXED(3.141592653,2)

FIXED(966364281,4,1)

Syntax

FIXED(number, number_of_places, suppress_separator)

  • number - The number to format.

  • number_of_places - The number of decimal places to display in the result.

    • If number has fewer than number_of_places significant digits, zeros will be appended. If it has greater thannumber_of_places significant digits, number will be rounded to the correct number_of_places rather than truncated.

  • suppress_separator - [ OPTIONAL - 0 by default ] - Whether or not to suppress the thousands separator used in some locales (e.g. 1,000 becomes 1000). Separators will be present if this value is 0 or omitted, and absent otherwise.

In order to use the FIXED formula, start with your edited Excellentable:

Then type in the FIXED formula in the area you would like to display the outcome:

By adding the values you would like to calculate the FIXED formula for, Excellentable will generate the outcome:

 

A
B
1
Data
2
1234.567
3
-1234.567
4
44.332
5
6
Round the number in A2 one digit to the right of the decimal point:
1,234.6
7
8

Round the number in A2 one digit to the left of the decimal point:
1,230
9
10
Round the number in A3 one digit to the left of the decimal point, without commas (the TRUE argument):
-1230
11
12
Rounds the number in A4 two digits to the left of the decimal point:
44.33

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close