Products, services, and OS functions
may not be available in this country.

FIXED

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

FIXED(num, places, no-commas)

num: The number value to format as a string.

places: An optional number value indicating the number of places to the right, or left, of the decimal point at which rounding should occur. When rounding to the specified number of places, round-half-up is used. If the most significant digit being dropped is 5 or greater, the result is rounded up. A negative number indicates rounding should occur to the left of the decimal (for example, round to hundreds or thousands).

no-commas: An optional modal value indicating whether to use position separators in the whole portion of the resulting number.

use commas (FALSE, 0, or omitted): Include position separators in the result.

no commas (TRUE or 1): Don’t include position separators in the result.

Examples

=FIXED(6789.123, 2) returns "6,789.12."

=FIXED(6789.123, 1, 1) returns "6789.1."

=FIXED(6789.123, -2) returns "6,800."

=FIXED(12.4, 0) returns "12."

=FIXED(12.5, 0) returns "13."

=FIXED(4, -1) returns "0."

=FIXED(5, -1) returns "10."

See alsoDOLLAR
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.