How to Rounds off number in MS Excel / How to Use FIXED function (formula) in Microsoft Excel

FIXED

Use of FIXED Function/Formula in Microsoft Excel:

This formula/Function helps to rounds a number to specified number of decimals in particular cell.
And also it formats the number in decimal format using a period and commas and returns the result as text.

Syntax/Formula :

The syntax of FIXED function in Microsoft Excel is below.

=FIXED(number,[decimals],[no-commas])

Example :

Step 1: First type any decimal number such as 5000000.96 in cell B4.

Step 2: Type formula =FIXED(B4,1,) in cell B6 and press enter.

FIXED