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.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.