Fixed Function in excel is a function that rounds a number to the specified numbers of decimals and returns as text with or without commas.
Syntax of the Fixed function is
Number: The number you want to round, you can provide the number directly or reference of number.
Decimals: It is optional, After decimal how many digits you want to round the number, you can mentions here. By default, it is 2.
No_commas: True for preventing commas and False for not preventing commas. By default, it gives the result with commas.
Syntax of the Fixed function is
=FIXED(Number,[decimals],[no_commas])Arguments
Number: The number you want to round, you can provide the number directly or reference of number.
Decimals: It is optional, After decimal how many digits you want to round the number, you can mentions here. By default, it is 2.
No_commas: True for preventing commas and False for not preventing commas. By default, it gives the result with commas.
No comments:
Post a Comment