FIXED

Definition: FIXED is a function that rounds a number to a specified number of decimal places and formats the result with commas and a currency symbol.

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

Situation: This formula is suitable when you need to round a number to a specified number of decimal places and format the result with commas and a currency symbol.

Example: If you have a number 1000.123 and want to round it to two decimal places with commas and a dollar sign, the formula =FIXED(1000.123, 2, TRUE) can be used, which returns “$1,000.12”.