From c48d8ad018dbe18632e3b0454874d4e0b4fb1757 Mon Sep 17 00:00:00 2001 From: Alain Romedenne Date: Wed, 31 Mar 2021 16:26:12 +0200 Subject: tdf#140553 =FIXED documentation Change-Id: Id1326425a51e9c687c322e61a17d47ab9072eb4d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/113364 Tested-by: Jenkins Reviewed-by: Steve Fanning Reviewed-by: Rafael Lima --- source/text/scalc/01/04060110.xhp | 18 ++++++++++++------ 1 file changed, 12 insertions(+), 6 deletions(-) diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 0c8859a615..8aadf252a8 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -289,17 +289,23 @@

FIXED

-Returns a number as text with a specified number of decimal places and optional thousands separators. +Returns a number as text with a specified number of decimal places and optional thousands separators. + -FIXED(Number; Decimals [; NoThousandsSeparators]) - Number refers to the number to be formatted. - Decimals refers to the number of decimal places to be displayed. - NoThousandsSeparators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed. +FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]]) + + Number is rounded to Decimals places (after the decimal separator) and the result formatted as text, using locale-specific settings. + Decimals (optional) refers to the number of decimal places to be displayed. If Decimals is negative, Number is rounded to ABS(Decimals) places to the left from the decimal point. If Decimals is a fraction, it is truncated actually ignoring what is the closest integer. + NoThousandsSeparators (optional) determines whether the thousands separator is used. If it is TRUE or non-zero, then group separators are omitted from the resulting string. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed. =FIXED(1234567.89;3) returns 1,234,567.890 as a text string. - =FIXED(1234567.89;3;1) returns 1234567.890 as a text string. + =FIXED(123456.789;;TRUE) returns 123456.79 as a text string. + =FIXED(12345.6789;-2) returns 12,300 as a text string. + =FIXED(12134567.89;-3;1) returns 12135000 as a text string. + =FIXED(12345.789;3/4) returns 12,346 as a text string. + =FIXED(12345.789,8/5) returns 12,345.8 as a text string.
-- cgit