Excel Fixed Function

This post will guide you how to use Excel FIXED function with syntax and examples in Microsoft excel.

Description

The Excel FIXED function rounds a number to the specified number of decimal places and returns the result as text string.

The FIXED function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The FIXED function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the FIXED function is as below:

= FIXED(number, [decimals],[no_commas])

Where the FIXED function arguments are:
number -This is a required argument. The number to be rounded and converted into text string.
Decimals-This is an optional argument. It will specify the number of decimal places to be displayed after decimal point.
No_commas– This is an optional argument.  This is a logical argument. If it is set to TRUE, the result will not separate number groups by commas, or commas are included in the result text string. (If this argument is omitted, the result text string will include commas as default)

Note: If Decimals value is omitted, it is set to be 2 by default.  If Decimals value is negative, the number is rounded to the left of the decimal point.

Example

The below examples will show you how to use Excel FIXED Text function to round a number to the specified number of decimal places.

#1 To round the number in B1 cell two digit to the right of the decimal point, just using FIXED(B1,2) formulas.

excel fixed function example1

#2 To round the number in B2 cell two digit to the left of the decimal point, just using FIXED(B1,-2) formulas.

excel fixed function example1

x
How to Replace # Errors with Zero or Any Specific Value in Excel

#3 To round the number in B3 cell two digit to the left of the decimal point without commas, just using FIXED(B1,-2,TRUE) formulas.

excel fixed function example1

Related Posts

Get full File Name (workbook and worksheet) and Path
Get the Current Worksheet Name only1

In excel, you can get the current workbook name and it is absolute path using the CELL function.  Just refer to the following formula: =CELL("filename",B1) Enter the above formula into any of cells in the current worksheet, then you will ...

Get the Current Worksheet Name only
Get the Current Worksheet Name only11

If you want to get the current worksheet name only in excel, you can use a combination of the MID function, the CELL function and FIND function. You can use the below generic formula: =MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255) The below explains how the ...

Data Validation for Specified Text only
Data Validation for Specified Text only1

If you want to check if the values that contain a specified text string in one cell, you can use a combination of the FIND function and ISNUMBER function as a formula in the Data Validation. Data Validation for Specified ...

Get the Current Workbook Name
Get the Current Workbook name5

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...

Get the Position of Second or Third of the Specified Character within a String
Get the Position of Second or Third of the Specified Character1

In the previous post, we have talked that how to split text string by a specified character in excel and it need to get the position of the first specified character within a string. And this post will guide you ...

Split Text and Numbers in Excel
Split Text and Numbers in Excel4

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Line Break in Excel
Split Text String by Line Break in Excel2

In the previous post, we talked that how to split text string by a specified character in excel. And this post will guide you how to split text string by Line Break character. The difference is that you can type ...

The difference between Replace function and Substitute function in Excel
The difference between Replace function and Substitute function1

There are two similar functions to replace text string in Excel. They are REPLACE and SUBSTITUTE functions. What’s the difference between REPLACE function and SUBSTITUTE function in excel 2013?  This post will introduce the difference between those two function in ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar