FIXED Excel Formula

Author Zaheer    Category Formulas     Tags ,

Most probably, everyone knows about Microsoft Excel. Excel is one of the most widely used spreadsheet program around the world. This computer software is one of the essences of the Microsoft Office versions. It has several features and functions from the simple ones that are extensively used by a lot of individuals whether at home or in workplace, up to the complex functions that would only ever be employed by the professionals in various fields. Excel provides a broad range of functions that offer numerous advantages to people especially during these days that the technology develops rapidly.

Today, many individuals utilize spreadsheet in their everyday life whether when doing simple tasks or even when working with the complicated ones. Although most people utilize spreadsheet for their fundamental function, Microsoft Excel contains a huge number of advanced functions that can be very helpful especially to those who require these functions in their respective fields. Excel also contains functions such as mathematical and financial functions for easy calculation of results. One of these powerful functions that Excel provides is the FIXED function. To learn more about it, here is an overview of the FIXED function, how it is used and some examples for a better understanding.

Basic Description of FIXED Function

The FIXED function in Microsoft Excel is used to round a number value to a particular number of decimal places and then the function converts the number value into text. The syntax of the FIXED function is:

FIXED(Number, [Decimals],[No_commas])

  • Number: This argument is the number value to be converted into text.
  • [Decimal]: This is an optional argument. This argument specifies the number of decimal places to be displayed right after the decimal point.

But you have to take note of the following:

If Decimal is left blank, it automatically takes the default value which is 2.

The entered number value is rounded up to the left of the decimal point if the Decimals argument is negative.

  • [No_commas]: This is also an optional logical argument. This argument specifies the returned text result if the thousands are to be separated by commas. The possible values for this argument are the following:

If TRUE, the returned text result doesn’t includes commas.

If FALSE, the returned text result does includes commas.

Note: If the [No_Commas] argument is left blank, it will automatically take the default value which is FALSE.

As an example, “123.591” is contained in cells A2 to A6.

If you use the formula, =FIXED(A2) and enter it in cell B2, leaving the [Decimals] and [No_Commas] arguments blank, the function will return the result which is 123.59. The result is will be displayed in cell B2. As you can see the result has two decimal places after the decimal point since the [Decimals] argument is omitted, it takes the default value of 2.

If you use the formula, =FIXED(A3,1) and enter it in cell B3, the function will return the result which is 123.6. As you will notice, the [Decimals] argument is 1, so the result has one decimal place after the decimal point.

For a better understanding of the topic, here is a detailed procedure on how to use the FIXED function in Microsoft Excel.

How to Use FIXED Function in Microsoft Excel

One of the advantages of MS Excel is that, it is capable of homogenizing and customizing data. If you need to create a professional report with reliable formatting all throughout, there are numerous functions in MS Excel that can assist you to do that. One of which is the FIXED function.

  • Of course, the first thing to do is to know what the FIXED function does. Once again, the FIXED function rounds off a numerical value to a specified number of decimals and the result is returned as text whether with or without commas.
  • Next, you need to complete the correct formula of the FIXED function which is: =FIXED(Number, Decimals, No_commas).
  • Then you can now use the FIXED function. For you to understand more about the function here is another example. You may type in hard numbers or use the cell references like A1. For example, “2627.3469373” is contained in cell A1. If you use the formula =FIXED(A1,3,TRUE), the function will return the result which is 2627.347. Furthermore, if you use the formula =FIXED(A1,4), the function will return the result which is 2,627.3469.

Post comment