diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-06-16 23:14:52 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-06-16 23:26:16 +0200 |
| commit | b3af6d45ec04aa0bb3861e7fb1eab95a66c822f2 (patch) | |
| tree | e66779ca82e3b5fa29b9f2bda2fb90c7b808cb95 /source/zh-TW/helpcontent2/source/text/scalc/01.po | |
| parent | 13d55bb42d2f5617f568fd8b000e3d0c8bc4be6b (diff) | |
update translations for 7.0 beta2
and force-fix errors using pocheck
Change-Id: I41df06b7c762dcaf88812f2667f02a6fae639e62
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/zh-TW/helpcontent2/source/text/scalc/01.po | 1045 |
1 files changed, 590 insertions, 455 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po index f6585c3d978..bb321514a54 100644 --- a/source/zh-TW/helpcontent2/source/text/scalc/01.po +++ b/source/zh-TW/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2020-05-27 11:43+0200\n" +"POT-Creation-Date: 2020-06-10 11:34+0200\n" "PO-Revision-Date: 2019-08-09 07:59+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -5830,13 +5830,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">Calculates the amount of depreciation for a settlement period as degressive amortization.</ahelp> Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here." msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORDEGRC\">計算一個結算週期內遞減分攤的折舊金額。</ahelp>與 AMORLINC 不同的是，此處使用了與折舊年限無關的折舊係數。" -#. DEtMa +#. G5ero #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147427\n" "help.text" -msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])" +msgid "AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis])" msgstr "" #. bA2pT @@ -5920,13 +5920,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_AMORLINC\">計算一個結算週期內線性分攤的折舊金額。如果在結算週期內購入了資本資產，則會考量一定比例的折舊金額。</ahelp>" -#. jD9JZ +#. 4PnLu #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147363\n" "help.text" -msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])" +msgid "AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate [; Basis])" msgstr "" #. PsFjE @@ -6019,13 +6019,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">Calculates the accrued interest of a security in the case of periodic payments.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINT\">計算債券分期支付時的應計利息。</ahelp>" -#. yGdCf +#. XHQ2B #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3159092\n" "help.text" -msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])" +msgid "ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency [; Basis])" msgstr "" #. PKp6i @@ -6064,14 +6064,23 @@ msgctxt "" msgid "<emph>Rate</emph> (required) is the annual nominal rate of interest (coupon interest rate)" msgstr "<emph>Rate</emph> 是指名義年利率 (票面利率)" -#. E6ARG +#. cAMCT #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3156445\n" "help.text" -msgid "<emph>Par</emph> (optional) is the par value of the security." -msgstr "<emph>Par</emph> 是指有價證券的票面價值。" +msgid "<emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used." +msgstr "" + +#. Ne2tH +#: 04060103.xhp +msgctxt "" +"04060103.xhp\n" +"par_id961591171682507\n" +"help.text" +msgid "We recommend that you always specify the value that you require for ACCRINT’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain." +msgstr "" #. Vobjm #: 04060103.xhp @@ -6127,13 +6136,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">Calculates the accrued interest of a security in the case of one-off payment at the settlement date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ACCRINTM\">計算在結算日期一次性支付的債券之應計利息。</ahelp>" -#. zFkiX +#. rrfir #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3147074\n" "help.text" -msgid "ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])" +msgid "ACCRINTM(Issue; Settlement; Rate [; Par [; Basis]])" msgstr "" #. pTobQ @@ -6217,13 +6226,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">計算固定利率的債券在指定時間點時付息的應收金額。</ahelp>" -#. BiDCz +#. D67BM #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3145362\n" "help.text" -msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])" +msgid "RECEIVED(Settlement; Maturity; Investment; Discount [; Basis])" msgstr "" #. oHAVz @@ -6334,13 +6343,13 @@ msgctxt "" msgid "Enter these values either as numbers, expressions or references. If, for example, interest is paid annually at 8%, but you want to use month as your period, enter 8%/12 under <emph>Rate</emph> and <item type=\"productname\">%PRODUCTNAME</item> Calc with automatically calculate the correct factor." msgstr "您可以將數值以數字、表示式或是參照的形式輸入。例如，年利率 8%，您想輸入月作為週期，則請在<emph>「利息」</emph>欄位中輸入 8%/12。<item type=\"productname\">%PRODUCTNAME</item> Calc 會自動計算正確的係數。" -#. uiDaD +#. 4cBxj #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3150395\n" "help.text" -msgid "PV(Rate; NPer; Pmt[; FV][; Type])" +msgid "PV(Rate; NPer; Pmt [; FV [; Type]])" msgstr "" #. JrCA6 @@ -7009,13 +7018,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DISC\">計算債券的折扣 (貼現) 百分比。</ahelp>" -#. fBGBA +#. nkAEs #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3149756\n" "help.text" -msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])" +msgid "DISC(Settlement; Maturity; Price; Redemption [; Basis])" msgstr "" #. Uyj29 @@ -7099,13 +7108,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\">計算固定利率的債券之年限。</ahelp>" -#. 7ixum +#. voaL4 #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153373\n" "help.text" -msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])" +msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis])" msgstr "" #. JeeVp @@ -7360,13 +7369,13 @@ msgctxt "" msgid "Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type." msgstr "如果您希望得到比線性折舊法更高的初始折舊值，請使用這種折舊方式。其折舊值在每個週期內逐次遞減，這種方式通常用於購買後在短期內價值損失非常大的資產 (例如汽車、電腦)。請註意，採用這種方式計算的帳面價值永不可能為零。" -#. EV3DT +#. veQBT #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3166452\n" "help.text" -msgid "DDB(Cost; Salvage; Life; Period[; Factor])" +msgid "DDB(Cost; Salvage; Life; Period [; Factor])" msgstr "" #. VKnDB @@ -7468,13 +7477,13 @@ msgctxt "" msgid "This form of depreciation is used if you want to get a higher depreciation value at the beginning of the depreciation (as opposed to linear depreciation). The depreciation value is reduced with every depreciation period by the depreciation already deducted from the initial cost." msgstr "如果您 (和線形折舊相反) 想要取得在折舊開始時較高的折舊值，則請使用此折舊格式。折舊值在每一折舊時間範圍都會根據已從資產值減去的折舊減少。" -#. EDXF8 +#. ExEAy #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153349\n" "help.text" -msgid "DB(Cost; Salvage; Life; Period[; Month])" +msgid "DB(Cost; Salvage; Life; Period [; Month])" msgstr "" #. caSta @@ -7585,13 +7594,13 @@ msgctxt "" msgid "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\" name=\"XIRR\">XIRR</link> function." msgstr "" -#. zWTAW +#. MXALn #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3155427\n" "help.text" -msgid "IRR(Values[; Guess])" +msgid "IRR(Values [; Guess])" msgstr "" #. o9R77 @@ -8341,13 +8350,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_IFERROR\">Returns the value if the cell does not contains an error value, or the alternative value if it does.</ahelp>" msgstr "" -#. ZUEHF +#. LREwJ #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id31531551\n" "help.text" -msgid "IFERROR(Value;Alternate_value)" +msgid "IFERROR(Value; Alternate_value)" msgstr "" #. wJRYc @@ -8890,13 +8899,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_IFNA\">Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does.</ahelp>" msgstr "" -#. pykHc +#. hQbWy #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id31537481\n" "help.text" -msgid "IFNA(Value;Alternate_value)" +msgid "IFNA(Value; Alternate_value)" msgstr "" #. 6oj7E @@ -9448,13 +9457,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZELLE\">Returns information on address, formatting or contents of a cell.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZELLE\">傳回儲存格的位置、格式或內容等資訊。</ahelp>" -#. RWBPC +#. Vwajg #: 04060104.xhp msgctxt "" "04060104.xhp\n" "par_id3147355\n" "help.text" -msgid "CELL(\"InfoType\"[; Reference])" +msgid "CELL(\"InfoType\" [; Reference])" msgstr "" #. wjBKt @@ -10195,13 +10204,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WENN\">Specifies a logical test to be performed.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WENN\">指定要執行的邏輯測試。</ahelp>" -#. qT9mo +#. ABZhn #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3154558\n" "help.text" -msgid "IF(Test[; ThenValue][; OtherwiseValue])" +msgid "IF(Test [; ThenValue [; OtherwiseValue]])" msgstr "" #. JnjcT @@ -11779,14 +11788,14 @@ msgctxt "" msgid "EXP" msgstr "EXP" -#. KCAqu +#. N7FBG #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3150592\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_EXP\">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904." -msgstr "<ahelp hid=\"HID_FUNC_EXP\">傳回增加為數字乘冪的 e。</ahelp>常數 e 的近似值為 2.71828182845904。" +msgid "<ahelp hid=\"HID_FUNC_EXP\">Returns <literal>e</literal> raised to the power of a number.</ahelp> The constant <literal>e</literal> has a value of approximately 2.71828182845904." +msgstr "" #. KxMFL #: 04060106.xhp @@ -11806,14 +11815,14 @@ msgctxt "" msgid "<emph>Number</emph> is the power to which e is to be raised." msgstr "<emph>Number</emph> 是以 e 為底數的乘冪。" -#. b8tDe +#. LfQsb #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3156340\n" "help.text" -msgid "<item type=\"input\">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy." -msgstr "<item type=\"input\">=EXP(1)</item> 傳回 2.71828182845904，此為接近 Calc 精準度的數學常數 e。" +msgid "<item type=\"input\">=EXP(1)</item> returns 2.71828182845904, the mathematical constant <literal>e</literal> to Calc's accuracy." +msgstr "" #. MSQJQ #: 04060106.xhp @@ -12580,14 +12589,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOG\">Returns the logarithm of a number to the specified base.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LOG\">傳回指定底數的數字之對數。</ahelp>" -#. WE376 +#. ShWCR #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3144732\n" "help.text" -msgid "LOG(Number; Base)" -msgstr "LOG(Number; Base)" +msgid "LOG(Number[; Base])" +msgstr "" #. Eiqiq #: 04060106.xhp @@ -12877,14 +12886,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Sums the first terms of a power series.</ahelp>" msgstr "<ahelp hid=\".\">計算第一次乘冪級數的總和。</ahelp>" -#. FhwbB +#. PffuD #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3152708\n" "help.text" -msgid "SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)" -msgstr "SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)" +msgid "SERIESSUM(x;n;m;c) = c<sub>1</sub>x<sup>n</sup> + c<sub>2</sub>x<sup>n+m</sup> + c<sub>3</sub>x<sup>n+2m</sup> + ... + c<sub>i</sub>x<sup>n + (i-1)m</sup>." +msgstr "" #. BM5eM #: 04060106.xhp @@ -13237,14 +13246,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RUNDEN\">Rounds a number to a certain number of decimal places.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RUNDEN\">將一個數四捨五入為一定小數點位數的數字。</ahelp>" -#. qcUKc +#. p64i9 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3158182\n" "help.text" -msgid "ROUND(Number; Count)" -msgstr "ROUND(Number; Count)" +msgid "ROUND(Number[; Count])" +msgstr "" #. yE5Jb #: 04060106.xhp @@ -13336,14 +13345,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ABRUNDEN\">Rounds a number down, toward zero, to a certain precision.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ABRUNDEN\">按指定位數向下捨入 (沿絕對值減小的方向) 數字。</ahelp>" -#. mJpd7 +#. uqe8Y #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3146051\n" "help.text" -msgid "ROUNDDOWN(Number; Count)" -msgstr "ROUNDDOWN(Number; Count)" +msgid "ROUNDDOWN(Number[; Count])" +msgstr "" #. EXn4P #: 04060106.xhp @@ -13426,14 +13435,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">Rounds a number up, away from zero, to a certain precision.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_AUFRUNDEN\">按指定位數向上 (沿絕對值增大的方向) 捨入數字。</ahelp>" -#. yz63F +#. smgCC #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3163328\n" "help.text" -msgid "ROUNDUP(Number; Count)" -msgstr "ROUNDUP(Number; Count)" +msgid "ROUNDUP(Number[; Count])" +msgstr "" #. x59Ls #: 04060106.xhp @@ -13903,14 +13912,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value." msgstr "<ahelp hid=\"HID_FUNC_SUMMEWENN\">增加給定條件所指定的儲存格。</ahelp> 當您搜尋特定值時，此函式用於瀏覽區域。" -#. Uy4kZ +#. PcPNo #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3152028\n" "help.text" -msgid "SUMIF(Range; Criteria; SumRange)" -msgstr "SUMIF(Range; Criteria; SumRange)" +msgid "SUMIF(Range; Criteria[; SumRange])" +msgstr "" #. rYzXG #: 04060106.xhp @@ -14425,14 +14434,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_UMRECHNEN\">Converts between old European national currency and to and from Euros.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_UMRECHNEN\">將舊的歐洲國家貨幣轉換成歐元，或從歐元轉換成舊的歐洲國家貨幣。</ahelp>" -#. S3ToS +#. qh8S5 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id3143748\n" "help.text" -msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\", full_precision, triangulation_precision)" -msgstr "EUROCONVERT(Value; \"From_currency\"; \"To_currency\", full_precision, triangulation_precision)" +msgid "EUROCONVERT(Value; \"From_currency\"; \"To_currency\"[; full_precision][; triangulation_precision])" +msgstr "" #. 4KJUc #: 04060106.xhp @@ -14911,14 +14920,14 @@ msgctxt "" msgid "<item type=\"input\">=SQRTPI(2)</item> returns the squareroot of (2PI), approximately 2.506628." msgstr "<item type=\"input\">=SQRTPI(2)</item> 傳回 (2PI) 的平方根，近似值為 2.506628。" -#. TvMZY +#. en4Ae #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3164669\n" "help.text" -msgid "<bookmark_value>random numbers; between limits</bookmark_value> <bookmark_value>RANDBETWEEN function</bookmark_value>" -msgstr "<bookmark_value>隨機數; 上下限之間</bookmark_value><bookmark_value>RANDBETWEEN 函式</bookmark_value>" +msgid "<bookmark_value>random numbers; between limits</bookmark_value><bookmark_value>RANDBETWEEN function</bookmark_value>" +msgstr "" #. vqzRX #: 04060106.xhp @@ -14983,14 +14992,77 @@ msgctxt "" msgid "<item type=\"input\">=RANDBETWEEN(20;30)</item> returns an integer of between 20 and 30." msgstr "<item type=\"input\">=RANDBETWEEN(20;30)</item> 傳回介於 20 與 30 之間的整數。" -#. CBgxC +#. Dmk3R +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"bm_id461590241346526\n" +"help.text" +msgid "<bookmark_value>random numbers non-volatile; between limits</bookmark_value><bookmark_value>RANDBETWEEN.NV function</bookmark_value>" +msgstr "" + +#. cgHiZ +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id171590240366277\n" +"help.text" +msgid "RANDBETWEEN.NV" +msgstr "" + +#. Akjyr +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id391590240473510\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RANDBETWEEN_NV\">Returns an non-volatile integer random number in a specified range.</ahelp>" +msgstr "" + +#. GTDa4 +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id181590240522012\n" +"help.text" +msgid "RANDBETWEEN.NV(Bottom; Top)" +msgstr "" + +#. q82vw +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id91590242400917\n" +"help.text" +msgid "Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated." +msgstr "" + +#. AngvN +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id151590240999839\n" +"help.text" +msgid "<input>=RANDBETWEEN.NV(20;30)</input> returns a non-volatile integer between 20 and 30." +msgstr "" + +#. cAQDh +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id1001590241005601\n" +"help.text" +msgid "<input>=RANDBETWEEN.NV(A1;30)</input> returns a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change." +msgstr "" + +#. odp65 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3164800\n" "help.text" -msgid "<bookmark_value>RAND function</bookmark_value> <bookmark_value>random numbers;between 0 and 1</bookmark_value>" -msgstr "<bookmark_value>RAND 函式</bookmark_value><bookmark_value>隨機數; 介於 0 與 1 之間</bookmark_value>" +msgid "<bookmark_value>RAND function</bookmark_value><bookmark_value>random numbers;between 0 and 1</bookmark_value>" +msgstr "" #. tTc7D #: 04060106.xhp @@ -15028,14 +15100,41 @@ msgctxt "" msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9." msgstr "" -#. Bb7HL +#. HAWnR #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id9312417\n" "help.text" -msgid "To generate random numbers which never recalculate, copy cells each containing =RAND(), and use <item type=\"menuitem\">Edit - Paste Special</item> (with <item type=\"menuitem\">Paste All</item> and <item type=\"menuitem\">Formulas</item> not marked and <item type=\"menuitem\">Numbers</item> marked)." -msgstr "若要產生從未重複計算的隨機數，請複製每個包含 =RAND() 的儲存格，然後使用 <item type=\"menuitem\">[編輯] - [選擇性貼上]</item> (不核取 <item type=\"menuitem\">[全部插入]</item> 與 <item type=\"menuitem\">[公式]</item> 但核取 <item type=\"menuitem\">[數字]</item>)。" +msgid "To generate random numbers which never recalculate, either:" +msgstr "" + +#. Ap4DT +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id451590242105253\n" +"help.text" +msgid "Copy cells each containing =RAND(), and use <menuitem>Edit - Paste Special</menuitem> (with <emph>Paste All</emph> and <emph>Formulas</emph> not marked and <emph>Numbers</emph> marked)." +msgstr "" + +#. zEFCC +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id801590242114296\n" +"help.text" +msgid "Use the Fill Cell command with random numbers (<menuitem>Sheet - Fill Cells - Fill Random Numbers</menuitem>)." +msgstr "" + +#. o9wUN +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id41590242118383\n" +"help.text" +msgid "Use the RAND.NV() function for non-volatile random numbers." +msgstr "" #. BLkte #: 04060106.xhp @@ -15046,6 +15145,60 @@ msgctxt "" msgid "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." msgstr "<item type=\"input\">=RAND()</item> 傳回介於 0 與 1 之間的隨機數。" +#. CqVpJ +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"bm_id341590241488944\n" +"help.text" +msgid "<bookmark_value>random numbers non-volatile;between 0 and 1</bookmark_value><bookmark_value>RAND.NV function</bookmark_value>" +msgstr "" + +#. q9iLd +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"hd_id71590238179170\n" +"help.text" +msgid "RAND.NV" +msgstr "" + +#. Fc2hv +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id101590238875834\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_RAND_NV\">Returns a non-volatile random number between 0 and 1.</ahelp>" +msgstr "" + +#. dchBL +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id391590238945182\n" +"help.text" +msgid "RAND.NV()" +msgstr "" + +#. QARNV +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id271590239748534\n" +"help.text" +msgid "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function. The function is recalculated when opening the file." +msgstr "" + +#. sCwno +#: 04060106.xhp +msgctxt "" +"04060106.xhp\n" +"par_id191590241215013\n" +"help.text" +msgid "<input>=RAND.NV()</input> returns a non-volatile random number between 0 and 1." +msgstr "" + #. Zsp2R #: 04060107.xhp msgctxt "" @@ -16180,14 +16333,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RGP\">Returns a table of statistics for a straight line that best fits a data set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RGP\">傳回最符合資料集的直線統計表。</ahelp>" -#. VTZV4 +#. 7YFEn #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3152839\n" "help.text" -msgid "LINEST(data_Y; data_X; linearType; stats)" -msgstr "LINEST(data_Y; data_X; linearType; stats)" +msgid "LINEST(data_Y [; data_X [; linearType [; stats]]])" +msgstr "" #. M2QFp #: 04060107.xhp @@ -16648,14 +16801,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RKP\">This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RKP\">此函式會將輸入之資料的調整計算成指數迴歸曲線 (y=b*m^x)。</ahelp>" -#. VFJDG +#. rdZCV #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3163123\n" "help.text" -msgid "LOGEST(DataY; DataX; FunctionType; Stats)" -msgstr "LOGEST(DataY; DataX; FunctionType; Stats)" +msgid "LOGEST(DataY [; DataX [; FunctionType [; Stats]]])" +msgstr "" #. 8jgzC #: 04060107.xhp @@ -16990,14 +17143,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TREND\">Returns values along a linear trend.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_TREND\">傳回伴隨線性趨勢的值。</ahelp>" -#. nuyCr +#. f8Ftr #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3166122\n" "help.text" -msgid "TREND(DataY; DataX; NewDataX; LinearType)" -msgstr "TREND(DataY; DataX; NewDataX; LinearType)" +msgid "TREND(DataY [; DataX [; NewDataX [; LinearType]]])" +msgstr "" #. qeK4r #: 04060107.xhp @@ -17071,14 +17224,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VARIATION\">Calculates the points of an exponential trend in an array.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VARIATION\">計算陣列中指數趨勢的點。</ahelp>" -#. kbYCk +#. 8VMBq #: 04060107.xhp msgctxt "" "04060107.xhp\n" "par_id3166377\n" "help.text" -msgid "GROWTH(DataY; DataX; NewDataX; FunctionType)" -msgstr "GROWTH(DataY; DataX; NewDataX; FunctionType)" +msgid "GROWTH(DataY [; DataX [; NewDataX [; FunctionType]]])" +msgstr "" #. CA3qD #: 04060107.xhp @@ -17341,14 +17494,14 @@ msgctxt "" msgid "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function." msgstr "儲存 INDIRECT 函式並不會轉換為 ODF 1.0/1.1 格式。若第二個參數存在，舊版的 Calc 會傳回該函式發生錯誤。" -#. UnrfB +#. TgFFT #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154707\n" "help.text" -msgid "ADDRESS(Row; Column; Abs; A1; \"Sheet\")" -msgstr "ADDRESS(Row; Column; Abs; A1; \"Sheet\")" +msgid "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])" +msgstr "" #. FyoLc #: 04060109.xhp @@ -17557,14 +17710,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed." msgstr "<ahelp hid=\"HID_FUNC_DDE\">傳回 DDE 基礎連結的結果。</ahelp> 如果連結範圍或區段的內容變更，傳回的值也會變更。您必須重新載入試算表或選擇 <emph>[編輯] - [連結]</emph>，以查看已更新的連結。不允許跨平台連結，例如從在 Windows 機器上執行的 <item type=\"productname\">%PRODUCTNAME</item> 安裝連結至在 Linux 機器上建立的文件。" -#. RarPk +#. JBRdm #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3148886\n" "help.text" -msgid "DDE(\"Server\"; \"File\"; \"Range\"; Mode)" -msgstr "DDE(\"Server\"; \"File\"; \"Range\"; Mode)" +msgid "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" +msgstr "" #. qAN6x #: 04060109.xhp @@ -17782,14 +17935,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_INDEX\">INDEX 傳回子範圍，此子範圍由列號與欄號或選用的範圍索引所指定。根據環境之不同，INDEX 會傳回參照或內容。</ahelp>" -#. GSBMC +#. T659Y #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149007\n" "help.text" -msgid "INDEX(Reference; Row; Column; Range)" -msgstr "INDEX(Reference; Row; Column; Range)" +msgid "INDEX(Reference [; Row [; Column [; Range]]])" +msgstr "" #. Btvgz #: 04060109.xhp @@ -17917,14 +18070,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_INDIREKT\">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string." msgstr "<ahelp hid=\"HID_FUNC_INDIREKT\">傳回文字字串指定的<emph>參照</emph>。</ahelp>此函式也可用於傳回對應字串的區域。" -#. CFFmo +#. hDCWQ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149824\n" "help.text" -msgid "INDIRECT(Ref; A1)" -msgstr "INDIRECT(Ref; A1)" +msgid "INDIRECT(Ref [; A1])" +msgstr "" #. cZG9F #: 04060109.xhp @@ -17998,14 +18151,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"array\">array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." msgstr "<ahelp hid=\"HID_FUNC_SPALTE\">傳回儲存格參照的欄號。</ahelp> 如果參照是儲存格，則會傳回儲存格的欄號；如果參照是儲存格範圍，則以一列<link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"陣列\">陣列</link> (如果公式<link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"作為陣列公式\">作為陣列公式</link>輸入)的形式傳回對應的欄號。如果具有區域參照參數的函式 COLUMN 未用於陣列公式，則僅傳回此區域中第一個儲存格的欄號。" -#. WjjYp +#. poCRX #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149447\n" "help.text" -msgid "COLUMN(Reference)" -msgstr "COLUMN(Reference)" +msgid "COLUMN([Reference])" +msgstr "" #. CAB6L #: 04060109.xhp @@ -18178,13 +18331,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." msgstr "" -#. qkLkD +#. 8FhyJ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150156\n" "help.text" -msgid "=VLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgid "=VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" msgstr "" #. 7FsgG @@ -18286,14 +18439,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." msgstr "<ahelp hid=\"HID_FUNC_TABELLE\">傳回參照的試算表數或代表試算表名稱的字串。</ahelp> 如果您並未輸入任何參數，結果為包含公式的試算表之試算表編號。" -#. 4WMzx +#. KRzAZ #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3153095\n" "help.text" -msgid "SHEET(Reference)" -msgstr "SHEET(Reference)" +msgid "SHEET([Reference])" +msgstr "" #. 9yCD8 #: 04060109.xhp @@ -18340,14 +18493,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." msgstr "<ahelp hid=\"HID_FUNC_TABELLEN\">決定參照中的試算表數。</ahelp> 如果您並未輸入任何參數，則會傳回目前文件中的試算表數。" -#. EfUeE +#. j5Aps #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3150777\n" "help.text" -msgid "SHEETS(Reference)" -msgstr "SHEETS(Reference)" +msgid "SHEETS([Reference])" +msgstr "" #. 5B3KF #: 04060109.xhp @@ -18394,14 +18547,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." msgstr "<ahelp hid=\"HID_FUNC_VERGLEICH\">傳回陣列中符合指定值的項目相關位置。</ahelp> 函式傳回 lookup_array 中找到為數字的值位置。" -#. Rg5W8 +#. FsB8G #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3159152\n" "help.text" -msgid "MATCH(SearchCriterion; LookupArray; Type)" -msgstr "MATCH(SearchCriterion; LookupArray; Type)" +msgid "MATCH(SearchCriterion; LookupArray [; Type])" +msgstr "" #. BmVBr #: 04060109.xhp @@ -18484,14 +18637,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">依指定參照點特定的列與欄數傳回儲存格偏移的值。</ahelp>" -#. CHJcg +#. nED4F #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3159194\n" "help.text" -msgid "OFFSET(Reference; Rows; Columns; Height; Width)" -msgstr "OFFSET(Reference; Rows; Columns; Height; Width)" +msgid "OFFSET(Reference; Rows; Columns [; Height [; Width]])" +msgstr "" #. 3Q5gL #: 04060109.xhp @@ -18655,14 +18808,14 @@ msgctxt "" msgid "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." msgstr "若 LOOKUP 找不到搜尋條件，則會於搜尋向量中搜尋小於或等於搜尋條件的最大值。" -#. eqrFF +#. 4nBA6 #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154104\n" "help.text" -msgid "LOOKUP(SearchCriterion; SearchVector; ResultVector)" -msgstr "LOOKUP(SearchCriterion; SearchVector; ResultVector)" +msgid "LOOKUP(SearchCriterion; SearchVector [; ResultVector])" +msgstr "" #. QdiFz #: 04060109.xhp @@ -18727,14 +18880,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VORLAGE\">Applies a style to the cell containing the formula.</ahelp> After a set amount of time, another style can be applied. This function always returns the value 0, allowing you to add it to another function without changing the value. Together with the CURRENT function you can apply a color to a cell depending on the value. For example: =...+STYLE(IF(CURRENT()>3;\"red\";\"green\")) applies the style \"red\" to the cell if the value is greater than 3, otherwise the style \"green\" is applied. Both cell formats, \"red\" and \"green\" have to be defined beforehand." msgstr "" -#. gNaP4 +#. gU3TE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149302\n" "help.text" -msgid "STYLE(\"Style\"; Time; \"Style2\")" -msgstr "STYLE(\"Style\"; Time; \"Style2\")" +msgid "STYLE(\"Style\" [; Time [; \"Style2\"]])" +msgstr "" #. Q8SMG #: 04060109.xhp @@ -18826,31 +18979,31 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WAHL\">使用索引傳回來自清單的值，可多達 30 個值。</ahelp>" -#. g9AE7 +#. r7bDk #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3155425\n" "help.text" -msgid "CHOOSE(Index; Value1; ...; Value30)" -msgstr "CHOOSE(Index; Value1; ...; Value30)" +msgid "CHOOSE(Index; Value1 [; Value2 [; ... [; Value254]]])" +msgstr "" -#. CNK7e +#. dt8SY #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3144755\n" "help.text" -msgid "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." -msgstr "<emph>Index</emph> 作為 1 和 30 之間的參照或數字，指定要從清單中取得哪一數值。" +msgid "<emph>Index</emph> is a reference or number between 1 and 254 indicating which value is to be taken from the list." +msgstr "" -#. jnAAs +#. nR3mX #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3149939\n" "help.text" -msgid "<emph>Value1, Value2, ..., Value30</emph> is the list of values entered as a reference to a cell or as individual values." +msgid "<emph>Value1, Value2, ..., Value254</emph> is the list of values entered as a reference to a cell or as individual values." msgstr "" #. s64Du @@ -18889,13 +19042,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">在選取的區域以下搜尋值與儲存格的參照。</ahelp> 此函式驗證陣列的第一列是否包含特定值。然後此函式傳回同一欄中由 <emph>Index</emph> 指定的陣列列中的數值。" -#. yxeCS +#. y6is6 #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3146070\n" "help.text" -msgid "HLOOKUP(SearchCriterion; Array; Index; SortedRangeLookup)" +msgid "HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])" msgstr "" #. nhwwF @@ -18934,14 +19087,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"Array\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"as an array formula\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned." msgstr "<ahelp hid=\"HID_FUNC_ZEILE\">傳回儲存格參照的列號。</ahelp> 如果參照是儲存格，則會傳回儲存格的列號。如果參照是儲存格範圍，則以一欄<link href=\"text/scalc/01/04060107.xhp#wasmatrix\" name=\"陣列\">陣列</link> (如果公式<link href=\"text/scalc/01/04060107.xhp#somatrixformel\" name=\"作為陣列公式\">作為陣列公式</link>輸入) 的形式傳回對應的列號 。如果具有範圍參照的 ROW 函式不在陣列公式使用，則僅將傳回第一個範圍儲存格的列號。" -#. 2F22B +#. 97EEE #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id3154916\n" "help.text" -msgid "ROW(Reference)" -msgstr "ROW(Reference)" +msgid "ROW([Reference])" +msgstr "" #. mSqrb #: 04060109.xhp @@ -19132,14 +19285,14 @@ msgctxt "" msgid "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." msgstr "若要使用鍵盤開啟超連結的儲存格，選取儲存格後按下 F2 鍵以進入編輯模式，將游標移至超連結前面並按下 Shift+F10 組合鍵，然後選擇 <emph>[開啟超連結]</emph>。" -#. JDWzm +#. BzM9o #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_idN1180E\n" "help.text" -msgid "HYPERLINK(\"URL\") or HYPERLINK(\"URL\"; \"CellText\")" -msgstr "HYPERLINK(\"URL\") 或 HYPERLINK(\"URL\"; \"CellText\")" +msgid "HYPERLINK(\"URL\" [; \"CellText\"])" +msgstr "" #. UbAEY #: 04060109.xhp @@ -19663,14 +19816,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"numbering system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used." msgstr "<ahelp hid=\"HID_FUNC_BASIS\">將指定底數的正整數轉換為 <link href=\"text/shared/00/00000005.xhp#zahlensystem\" name=\"數字系統\">數字系統</link> 的文字。</ahelp> 將使用數字 0-9 以及字母 A-Z。" -#. w9kd3 +#. 2cDvi #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155743\n" "help.text" -msgid "BASE(Number; Radix; [MinimumLength])" -msgstr "BASE(Number; Radix; [MinimumLength])" +msgid "BASE(Number; Radix [; MinimumLength])" +msgstr "" #. iDR7A #: 04060110.xhp @@ -20104,14 +20257,14 @@ msgctxt "" msgid "You set the currency format in your system settings." msgstr "您在系統設定中設定貨幣格式。" -#. hAiEu +#. icFpC #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154188\n" "help.text" -msgid "DOLLAR(Value; Decimals)" -msgstr "DOLLAR(Value; Decimals)" +msgid "DOLLAR(Value [; Decimals])" +msgstr "" #. WA6bA #: 04060110.xhp @@ -20239,14 +20392,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_FINDEN\">Returns the position of a string of text within another string.</ahelp>You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive." msgstr "" -#. zQDEB +#. Kpkfu #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3083452\n" "help.text" -msgid "FIND(\"FindText\"; \"Text\"; Position)" -msgstr "FIND(\"FindText\"; \"Text\"; Position)" +msgid "FIND(\"FindText\"; \"Text\" [; Position])" +msgstr "" #. 3HU9t #: 04060110.xhp @@ -20311,14 +20464,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_FEST\">將數字作為具有指定小數點位數及可選千位分隔符的文字傳回。</ahelp>" -#. UtELQ +#. CEftz #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147567\n" "help.text" -msgid "FIXED(Number; Decimals; NoThousandsSeparators)" -msgstr "FIXED(Number; Decimals; NoThousandsSeparators)" +msgid "FIXED(Number; Decimals [; NoThousandsSeparators])" +msgstr "" #. 5cYW8 #: 04060110.xhp @@ -20455,14 +20608,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LINKS\">Returns the first character or characters of a text.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LINKS\">傳回文字中的第一個或前幾個字元。</ahelp>" -#. wcSFE +#. yAT6p #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3146786\n" "help.text" -msgid "LEFT(\"Text\"; Number)" -msgstr "LEFT(\"Text\"; Number)" +msgid "LEFT(\"Text\" [; Number])" +msgstr "" #. PGbwK #: 04060110.xhp @@ -20518,14 +20671,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LEFTB\">Returns the first characters of a DBCS text.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LEFTB\">傳回雙位元字元集文字的第一個字元。</ahelp>" -#. 2x4Vt +#. ZcHDR #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2946786\n" "help.text" -msgid "LEFTB(\"Text\"; Number_bytes)" -msgstr "LEFTB(\"Text\"; Number_bytes)" +msgid "LEFTB(\"Text\" [; Number_bytes])" +msgstr "" #. e6CdQ #: 04060110.xhp @@ -21076,14 +21229,14 @@ msgctxt "" msgid "<emph>Text</emph> refers to the text to be converted." msgstr "<emph>Text</emph> 是指要轉換的文字。" -#. CHBWP +#. Nt5dD #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3155364\n" "help.text" -msgid "<item type=\"input\">=PROPER(\"open office\")</item> returns Open Office." -msgstr "<item type=\"input\">=PROPER(\"open office\")</item> 傳回 Open Office。" +msgid "<item type=\"input\">=PROPER(\"the document foundation\")</item> returns The Document Foundation." +msgstr "" #. MeADa #: 04060110.xhp @@ -21274,14 +21427,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RECHTS\">Returns the last character or characters of a text.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RECHTS\">傳回文字中的最後一個或後幾個字元。</ahelp>" -#. STrAH +#. 3D3E9 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154344\n" "help.text" -msgid "RIGHT(\"Text\"; Number)" -msgstr "RIGHT(\"Text\"; Number)" +msgid "RIGHT(\"Text\" [; Number])" +msgstr "" #. dveYp #: 04060110.xhp @@ -21337,14 +21490,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RIGHTB\">Returns the last character or characters of a text with double bytes characters sets (DBCS).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RIGHTB\">傳回雙位元字元集 (DBCS) 文字的最後幾個字元。</ahelp>" -#. B2AWW +#. 9kB2q #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id2954344\n" "help.text" -msgid "RIGHTB(\"Text\"; Number_bytes)" -msgstr "RIGHTB(\"Text\"; Number_bytes)" +msgid "RIGHTB(\"Text\" [; Number_bytes])" +msgstr "" #. jvjXS #: 04060110.xhp @@ -21436,14 +21589,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ROEMISCH\">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ROEMISCH\">將數字轉換成羅馬數字。數值必須介於 0 到 3999 之間，Mode 的值可以是 0 到 4 之間的整數。</ahelp>" -#. 4bqzs +#. RdCBS #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3150593\n" "help.text" -msgid "ROMAN(Number; Mode)" -msgstr "ROMAN(Number; Mode)" +msgid "ROMAN(Number [; Mode])" +msgstr "" #. 4rcTC #: 04060110.xhp @@ -21544,14 +21697,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_SUCHEN\">Returns the position of a text segment within a character string.</ahelp> You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. If the text is not found, returns error 519 (#VALUE)." msgstr "" -#. FN6o9 +#. GU5p2 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3154671\n" "help.text" -msgid "SEARCH(\"FindText\"; \"Text\"; Position)" -msgstr "SEARCH(\"FindText\"; \"Text\"; Position)" +msgid "SEARCH(\"FindText\"; \"Text\" [; Position])" +msgstr "" #. yP57Q #: 04060110.xhp @@ -21616,14 +21769,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WECHSELN\">Substitutes new text for old text in a string.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_WECHSELN\">用新文字代替字串中的舊文字。</ahelp>" -#. L6DKo +#. K2fp5 #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id3147582\n" "help.text" -msgid "SUBSTITUTE(\"Text\"; \"SearchText\"; \"NewText\"; Occurrence)" -msgstr "SUBSTITUTE(\"Text\"; \"SearchText\"; \"NewText\"; Occurrence)" +msgid "SUBSTITUTE(\"Text\"; \"SearchText\"; \"NewText\" [; Occurrence])" +msgstr "" #. tydqc #: 04060110.xhp @@ -24505,14 +24658,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_BIN2HEX\">The result is the hexadecimal number for the binary number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_BIN2HEX\">結果為輸入的二進制數字對應的十六進制數字。</ahelp>" -#. k5VGV +#. pLG3U #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3148753\n" "help.text" -msgid "BIN2HEX(Number; Places)" -msgstr "BIN2HEX(Number; Places)" +msgid "BIN2HEX(Number [; Places])" +msgstr "" #. 9ugAE #: 04060115.xhp @@ -24568,14 +24721,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_BIN2OCT\"> The result is the octal number for the binary number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_BIN2OCT\"> 結果為輸入的二進位數字對應的八進制數字。</ahelp>" -#. 2DBBD +#. 8pRVA #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3154508\n" "help.text" -msgid "BIN2OCT(Number; Places)" -msgstr "BIN2OCT(Number; Places)" +msgid "BIN2OCT(Number [; Places])" +msgstr "" #. kBSNf #: 04060115.xhp @@ -24631,14 +24784,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DELTA\">The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0).</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DELTA\">如果傳送為引數的兩個數字相等，則結果為 TRUE (1) 否則為 FALSE (0)。</ahelp>" -#. 73wCN +#. 6s5yD #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3145247\n" "help.text" -msgid "DELTA(Number1; Number2)" -msgstr "DELTA(Number1; Number2)" +msgid "DELTA(Number1 [; Number2])" +msgstr "" #. PEgQC #: 04060115.xhp @@ -24676,14 +24829,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2BIN\"> The result is the binary number for the decimal number entered between -512 and 511.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2BIN\"> 結果為所輸入十進制數字介於 -512 與 511 之間的二進制數字。</ahelp>" -#. NUeb8 +#. tPFjB #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3150569\n" "help.text" -msgid "DEC2BIN(Number; Places)" -msgstr "DEC2BIN(Number; Places)" +msgid "DEC2BIN(Number [; Places])" +msgstr "" #. Y9mGB #: 04060115.xhp @@ -24739,14 +24892,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2HEX\">The result is the hexadecimal number for the decimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2HEX\">結果為輸入的十進制數字對應的十六進制數字。</ahelp>" -#. 4BMnA +#. T8PpC #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3147535\n" "help.text" -msgid "DEC2HEX(Number; Places)" -msgstr "DEC2HEX(Number; Places)" +msgid "DEC2HEX(Number [; Places])" +msgstr "" #. SQafk #: 04060115.xhp @@ -24802,14 +24955,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DEC2OCT\">The result is the octal number for the decimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DEC2OCT\">結果為輸入的十進制數字對應的八進制數字。</ahelp>" -#. FPyVU +#. 5ecSa #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3148427\n" "help.text" -msgid "DEC2OCT(Number; Places)" -msgstr "DEC2OCT(number;places)" +msgid "DEC2OCT(Number [; Places])" +msgstr "" #. Fa6gd #: 04060115.xhp @@ -24865,14 +25018,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ERF\">Returns values of the Gaussian error integral.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ERF\">傳回高斯誤差積分的值。</ahelp>" -#. nDWWi +#. KmGKW #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3163824\n" "help.text" -msgid "ERF(LowerLimit; UpperLimit)" -msgstr "ERF(LowerLimit; UpperLimit)" +msgid "ERF(LowerLimit [; UpperLimit])" +msgstr "" #. TyCGk #: 04060115.xhp @@ -25090,14 +25243,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_GESTEP\">The result is 1 if <item type=\"literal\">Number</item> is greater than or equal to <item type=\"literal\">Step</item>.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_GESTEP\">若 <item type=\"literal\">Number</item> 大於或等於 <item type=\"literal\">Step</item>，則結果為 1。</ahelp>" -#. iE7iA +#. cDDSb #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3145212\n" "help.text" -msgid "GESTEP(Number; Step)" -msgstr "GESTEP (Number; Step)" +msgid "GESTEP(Number [; Step])" +msgstr "" #. QG8JU #: 04060115.xhp @@ -25135,14 +25288,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_HEX2BIN\">The result is the binary number for the hexadecimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_HEX2BIN\">結果為輸入的十六進制數字對應的二進制數字。</ahelp>" -#. UEfgv +#. S4Zyx #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3155847\n" "help.text" -msgid "HEX2BIN(Number; Places)" -msgstr "HEX2BIN(Number; Places)" +msgid "HEX2BIN(Number [; Places])" +msgstr "" #. YzMa9 #: 04060115.xhp @@ -25252,14 +25405,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_HEX2OCT\">The result is the octal number for the hexadecimal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_HEX2OCT\">結果為輸入的十六進制數字對應的八進制數字。</ahelp>" -#. 5ViJ3 +#. BoGKD #: 04060115.xhp msgctxt "" "04060115.xhp\n" "par_id3151170\n" "help.text" -msgid "HEX2OCT(Number; Places)" -msgstr "HEX2OCT(Number; Places)" +msgid "HEX2OCT(Number [; Places])" +msgstr "" #. 2Uff5 #: 04060115.xhp @@ -26134,14 +26287,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COMPLEX\">The result is a complex number which is returned from a real coefficient and an imaginary coefficient.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COMPLEX\">結果為從實際係數與虛係數傳回的複數。</ahelp>" -#. ayftD +#. c2huU #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3155999\n" "help.text" -msgid "COMPLEX(RealNum; INum; Suffix)" -msgstr "COMPLEX(RealNum; INum; Suffix)" +msgid "COMPLEX(RealNum; INum [; Suffix])" +msgstr "" #. FCxXC #: 04060116.xhp @@ -26206,14 +26359,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_OCT2BIN\">The result is the binary number for the octal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_OCT2BIN\">結果為輸入的八進制數字對應的二進位數字。</ahelp>" -#. KWCgD +#. BTUGA #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3154303\n" "help.text" -msgid "OCT2BIN(Number; Places)" -msgstr "OCT2BIN(Number; Places)" +msgid "OCT2BIN(Number [; Places])" +msgstr "" #. AbzaY #: 04060116.xhp @@ -26323,14 +26476,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_OCT2HEX\"> The result is the hexadecimal number for the octal number entered.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_OCT2HEX\"> 結果為輸入的八進制數字對應的十六進制數字。</ahelp>" -#. FJ4Jp +#. dvEBj #: 04060116.xhp msgctxt "" "04060116.xhp\n" "par_id3150523\n" "help.text" -msgid "OCT2HEX(Number; Places)" -msgstr "OCT2HEX(Number; Places)" +msgid "OCT2HEX(Number [; Places])" +msgstr "" #. XAYGj #: 04060116.xhp @@ -27322,14 +27475,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFPRICE\">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDFPRICE\">如果首期付息日期不固定，計算票面價值為 100 貨幣單位的債券價格。</ahelp>" -#. SD7Pr +#. BvVwj #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3146098\n" "help.text" -msgid "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)" +msgid "ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. kHZM8 #: 04060118.xhp @@ -27430,14 +27583,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDFYIELD\">Calculates the yield of a security if the first interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDFYIELD\">如果首期付息日不固定，計算債券的收益。</ahelp>" -#. GpJqj +#. nGSvB #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3152982\n" "help.text" -msgid "ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis)" -msgstr "ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis)" +msgid "ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. nJXTW #: 04060118.xhp @@ -27538,14 +27691,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLPRICE\">Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDLPRICE\">如果末期付息日不固定，計算票面價值為 100 貨幣單位的債券價格。</ahelp>" -#. XAt33 +#. ozTCG #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155262\n" "help.text" -msgid "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis)" +msgid "ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. iTfu4 #: 04060118.xhp @@ -27664,14 +27817,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_ODDLYIELD\">Calculates the yield of a security if the last interest date falls irregularly.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_ODDLYIELD\">如果末期付息日不固定，計算債券的收益。</ahelp>" -#. gVBSg +#. pwm9F #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3150018\n" "help.text" -msgid "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis)" -msgstr "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis)" +msgid "ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. 4X7wa #: 04060118.xhp @@ -27790,13 +27943,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_VDB\">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_VDB\">使用變數遞減結餘法，傳回指定或部分週期內資產的折舊金額。</ahelp>" -#. PiFjC +#. DSd3v #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149025\n" "help.text" -msgid "VDB(Cost; Salvage; Life; S; End; Factor; NoSwitch)" +msgid "VDB(Cost; Salvage; Life; S; End [; Factor [; NoSwitch]])" msgstr "" #. zGhDb @@ -27916,14 +28069,14 @@ msgctxt "" msgid "If the payments take place at regular intervals, use the <link href=\"text/scalc/01/04060103.xhp#irr\" name=\"IRR\">IRR</link> function." msgstr "" -#. qAG6C +#. CVXB7 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149826\n" "help.text" -msgid "XIRR(Values; Dates; Guess)" -msgstr "XIRR(Values; Dates; Guess)" +msgid "XIRR(Values; Dates [; Guess])" +msgstr "" #. GoDCv #: 04060118.xhp @@ -28339,14 +28492,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZINS\">Returns the constant interest rate per period of an annuity.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZINS\">傳回年金每週期的恆定利率。</ahelp>" -#. 6BqLB +#. wEYqD #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3158423\n" "help.text" -msgid "RATE(NPer; Pmt; PV; FV; Type; Guess)" -msgstr "RATE(NPer; Pmt; PV; FV; Type; Guess)" +msgid "RATE(NPer; Pmt; PV [ ; [ FV ] [ ; [ Type ] [ ; Guess ] ] ])" +msgstr "" #. kkBfr #: 04060118.xhp @@ -28447,14 +28600,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_INTRATE\">Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_INTRATE\">當債券 (或其他項目) 以投資值購買並以贖回值賣出時，計算結果的年利率。未支付任何利息。</ahelp>" -#. 9sGBJ +#. kFnJn #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149800\n" "help.text" -msgid "INTRATE(Settlement; Maturity; Investment; Redemption; Basis)" -msgstr "INTRATE(Settlement; Maturity; Investment; Redemption; Basis)" +msgid "INTRATE(Settlement; Maturity; Investment; Redemption [; Basis])" +msgstr "" #. 9szb8 #: 04060118.xhp @@ -28537,14 +28690,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNCD\">Returns the date of the first interest date after the settlement date. Format the result as a date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPNCD\">傳回結算日期之後的首期付息日期。將結果做成日期格式。</ahelp>" -#. HLdaB +#. 6sEfy #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3150423\n" "help.text" -msgid "COUPNCD(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPNCD(Settlement; Maturity; Frequency; Basis)" +msgid "COUPNCD(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. vGKDd #: 04060118.xhp @@ -28618,14 +28771,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYS\">Returns the number of days in the current interest period in which the settlement date falls.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYS\">傳回目前利息週期中結算日期的天數。</ahelp>" -#. pRREv +#. ALYbR #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3149585\n" "help.text" -msgid "COUPDAYS(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPDAYS(Settlement; Maturity; Frequency; Basis)" +msgid "COUPDAYS(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. UuJui #: 04060118.xhp @@ -28699,14 +28852,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\">Returns the number of days from the settlement date until the next interest date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\">傳回從結算日期到下個付息日的天數。</ahelp>" -#. UkhnP +#. 2AgvC #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155121\n" "help.text" -msgid "COUPDAYSNC(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPDAYSNC(Settlement; Maturity; Frequency; Basis)" +msgid "COUPDAYSNC(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. ECNxY #: 04060118.xhp @@ -28780,14 +28933,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\">Returns the number of days from the first day of interest payment on a security until the settlement date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\">傳回從債券利息支付的第一天至結算日期的天數。</ahelp>" -#. tFuDc +#. Zbdd9 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3159083\n" "help.text" -msgid "COUPDAYBS(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPDAYBS(Settlement; Maturity; Frequency; Basis)" +msgid "COUPDAYBS(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. CH3ja #: 04060118.xhp @@ -28861,14 +29014,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPPCD\">Returns the date of the interest date prior to the settlement date. Format the result as a date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPPCD\">傳回結算日期之前的上一個計息日。將結果做成日期格式。</ahelp>" -#. FBDqt +#. a3gA8 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3153790\n" "help.text" -msgid "COUPPCD(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPPCD(Settlement; Maturity; Frequency; Basis)" +msgid "COUPPCD(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. DCtJY #: 04060118.xhp @@ -28942,14 +29095,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_COUPNUM\">Returns the number of coupons (interest payments) between the settlement date and the maturity date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_COUPNUM\">傳回結算日期與到期日之間的息票數 (利息支付次數)。</ahelp>" -#. 4YreD +#. TbHua #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3153200\n" "help.text" -msgid "COUPNUM(Settlement; Maturity; Frequency; Basis)" -msgstr "COUPNUM(Settlement; Maturity; Frequency; Basis)" +msgid "COUPNUM(Settlement; Maturity; Frequency [; Basis])" +msgstr "" #. 7oq6X #: 04060118.xhp @@ -29023,14 +29176,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZINSZ\">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZINSZ\">計算一項定期支付且利率恆定的投資之分期償還週期。</ahelp>" -#. fWFAi +#. DPv99 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3151283\n" "help.text" -msgid "IPMT(Rate; Period; NPer; PV; FV; Type)" -msgstr "IPMT(Rate; Period; NPer; PV; FV; Type)" +msgid "IPMT(Rate; Period; NPer; PV [; FV [; Type]])" +msgstr "" #. WpENP #: 04060118.xhp @@ -29131,14 +29284,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZW\">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZW\">在定期等額支付與恆定利率的條件下，傳回一項投資的未來值 (Future Value)。</ahelp>" -#. SbUo7 +#. Gnz7u #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3145215\n" "help.text" -msgid "FV(Rate; NPer; Pmt; PV; Type)" -msgstr "FV(Rate; NPer; Pmt; PV; Type)" +msgid "FV(Rate; NPer; Pmt [ ; [ PV ] [ ; Type ] ])" +msgstr "" #. Y9GP8 #: 04060118.xhp @@ -29302,14 +29455,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_ZZR\">Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_ZZR\">在定期等額支付與恆定利率的條件下，傳回一項投資的支付週期數。</ahelp>" -#. EBZYF +#. Fopz2 #: 04060118.xhp msgctxt "" "04060118.xhp\n" "par_id3155934\n" "help.text" -msgid "NPER(Rate; Pmt; PV; FV; Type)" -msgstr "NPER(Rate; Pmt; PV; FV; Type)" +msgid "NPER(Rate; Pmt; PV [ ; [ FV ] [ ; Type ] ])" +msgstr "" #. X44J9 #: 04060118.xhp @@ -29455,14 +29608,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_KAPZ\">Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_KAPZ\">在定期等額支付和恒定利率的條件下，計算一項投資在指定週期的支付金額。</ahelp>" -#. B6Kor +#. gxWF2 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3146878\n" "help.text" -msgid "PPMT(Rate; Period; NPer; PV; FV; Type)" -msgstr "PPMT(Rate; Period; NPer; PV; FV; Type)" +msgid "PPMT(Rate; Period; NPer; PV [ ; FV [ ; Type ] ])" +msgstr "" #. t4fJk #: 04060119.xhp @@ -30067,14 +30220,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICE\">Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICE\">以作為預測收益函式的 100 貨幣單位等值來計算固定利息債券的市值。</ahelp>" -#. M699C +#. k7qtv #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3152804\n" "help.text" -msgid "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis)" -msgstr "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency; Basis)" +msgid "PRICE(Settlement; Maturity; Rate; Yield; Redemption; Frequency [; Basis])" +msgstr "" #. FUP24 #: 04060119.xhp @@ -30175,14 +30328,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICEDISC\">Calculates the price per 100 currency units of par value of a non-interest- bearing security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICEDISC\">計算不附息債券同等值票面價值 100 貨幣單位的價格。</ahelp>" -#. RwdWe +#. 6dK5H #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3146084\n" "help.text" -msgid "PRICEDISC(Settlement; Maturity; Discount; Redemption; Basis)" -msgstr "PRICEDISC(Settlement; Maturity; Discount; Redemption; Basis)" +msgid "PRICEDISC(Settlement; Maturity; Discount; Redemption [; Basis])" +msgstr "" #. WBvCG #: 04060119.xhp @@ -30265,14 +30418,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_PRICEMAT\">Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_PRICEMAT\">計算在到期日期支付利息的債券等值票面價值為 100 貨幣單位的價格。</ahelp>" -#. rYQMJ +#. h6UDj #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155393\n" "help.text" -msgid "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)" -msgstr "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield; Basis)" +msgid "PRICEMAT(Settlement; Maturity; Issue; Rate; Yield [; Basis])" +msgstr "" #. tG4zg #: 04060119.xhp @@ -30526,14 +30679,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_MDURATION\">Calculates the modified Macauley duration of a fixed interest security in years.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_MDURATION\">計算固定利率的債券之 Macauley 修正年限。</ahelp>" -#. AUGt7 +#. tGit8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148987\n" "help.text" -msgid "MDURATION(Settlement; Maturity; Coupon; Yield; Frequency; Basis)" -msgstr "MDURATION(Settlement; Maturity; Coupon; Yield; Frequency; Basis)" +msgid "MDURATION(Settlement; Maturity; Coupon; Yield; Frequency [; Basis])" +msgstr "" #. xTn69 #: 04060119.xhp @@ -31057,14 +31210,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELD\">Calculates the yield of a security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELD\">計算債券的收益。</ahelp>" -#. QYCYQ +#. iZ8rB #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3149744\n" "help.text" -msgid "YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency; Basis)" -msgstr "YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency; Basis)" +msgid "YIELD(Settlement; Maturity; Rate; Price; Redemption; Frequency [; Basis])" +msgstr "" #. C68Mv #: 04060119.xhp @@ -31165,14 +31318,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELDDISC\">Calculates the annual yield of a non-interest-bearing security.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELDDISC\">計算不附息債券的年收益。</ahelp>" -#. DhjQo +#. z5sGa #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3159191\n" "help.text" -msgid "YIELDDISC(Settlement; Maturity; Price; Redemption; Basis)" -msgstr "YIELDDISC(Settlement; Maturity; Price; Redemption; Basis)" +msgid "YIELDDISC(Settlement; Maturity; Price; Redemption [; Basis])" +msgstr "" #. fFG4g #: 04060119.xhp @@ -31255,14 +31408,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YIELDMAT\">Calculates the annual yield of a security, the interest of which is paid on the date of maturity.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_YIELDMAT\">計算債券的年收益，而債券的利息在到期日支付。</ahelp>" -#. auKJi +#. 63YEW #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3159113\n" "help.text" -msgid "YIELDMAT(Settlement; Maturity; Issue; Rate; Price; Basis)" -msgstr "YIELDMAT(Settlement; Maturity; Issue; Rate; Price; Basis)" +msgid "YIELDMAT(Settlement; Maturity; Issue; Rate; Price [; Basis])" +msgstr "" #. db9jM #: 04060119.xhp @@ -31354,14 +31507,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RMZ\">Returns the periodic payment for an annuity with constant interest rates.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RMZ\">傳回具有恆定利率的年金分期支付額。</ahelp>" -#. QNdx7 +#. 94VHK #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3147278\n" "help.text" -msgid "PMT(Rate; NPer; PV; FV; Type)" -msgstr "PMT(Rate; NPer; PV; FV; Type)" +msgid "PMT(Rate; NPer; PV [ ; [ FV ] [ ; Type ] ])" +msgstr "" #. fGg3G #: 04060119.xhp @@ -32425,14 +32578,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_B\">Returns the probability of a sample with binomial distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_B\">傳回具有二項式分佈的範例之概率。</ahelp>" -#. K7JLA +#. tYKH6 #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3148392\n" "help.text" -msgid "B(Trials; SP; T1; T2)" -msgstr "B(Trials; SP; T1; T2)" +msgid "B(Trials; SP; T1 [; T2])" +msgstr "" #. 5gx3q #: 04060181.xhp @@ -32578,14 +32731,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAINV\">Returns the inverse of the cumulative beta probability density function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAINV\">傳回 beta 概率密度函式的逆運算。</ahelp>" -#. GuWiC +#. 9kR89 #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3156300\n" "help.text" -msgid "BETAINV(Number; Alpha; Beta; Start; End)" -msgstr "BETAINV(Number; Alpha; Beta; Start; End)" +msgid "BETAINV(Number; Alpha; Beta [; Start [; End]])" +msgstr "" #. nrAdm #: 04060181.xhp @@ -32668,14 +32821,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAINV_MS\">Returns the inverse of the cumulative beta probability density function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAINV\">傳回 beta 概率密度函式的逆運算。</ahelp>" -#. vUjKp +#. xtGcA #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id2956300\n" "help.text" -msgid "BETA.INV(Number; Alpha; Beta; Start; End)" -msgstr "BETAINV(Number; Alpha; Beta; Start; End)" +msgid "BETA.INV(Number; Alpha; Beta [; Start [; End]])" +msgstr "" #. 2fKqs #: 04060181.xhp @@ -32758,14 +32911,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETAVERT\">Returns the beta function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAVERT\">傳回 beta 函式。</ahelp>" -#. hzgeo +#. AKfrR #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id3147571\n" "help.text" -msgid "BETADIST(Number; Alpha; Beta; Start; End; Cumulative)" -msgstr "BETADIST(Number; Alpha; Beta; Start; End; Cumulative)" +msgid "BETADIST(Number; Alpha; Beta [; Start [; End [; Cumulative]]])" +msgstr "" #. jfrX3 #: 04060181.xhp @@ -32857,13 +33010,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_BETADIST_MS\">Returns the beta function.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_BETAVERT\">傳回 beta 函式。</ahelp>" -#. vBbC8 +#. qpb3A #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id2947571\n" "help.text" -msgid "BETA.DIST(Number; Alpha; Beta; Cumulative; Start; End)" +msgid "BETA.DIST(Number; Alpha; Beta; Cumulative [; Start [; End]])" msgstr "" #. VV9bt @@ -34297,14 +34450,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.</ahelp>" msgstr "<ahelp hid=\".\">為卡方分佈傳回機率密度函式的值或累積分佈函式。</ahelp>" -#. yG245 +#. 9t3Cb #: 04060181.xhp msgctxt "" "04060181.xhp\n" "par_id0119200902395679\n" "help.text" -msgid "CHISQDIST(Number; Degrees Of Freedom; Cumulative)" -msgstr "CHISQDIST(Number; Degrees Of Freedom; Cumulative)" +msgid "CHISQDIST(Number; Degrees Of Freedom [; Cumulative])" +msgstr "" #. nLEaF #: 04060181.xhp @@ -35044,14 +35197,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_F_DIST_LT\">Calculates the values of the left tail of the F distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_TINV\">傳回 t 分佈的逆運算。</ahelp>" -#. CxzQP +#. kNsgP #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id2945826\n" "help.text" -msgid "F.DIST(Number; DegreesFreedom1; DegreesFreedom2; Cumulative)" -msgstr "FDIST(Number; DegreesFreedom1; DegreesFreedom2)" +msgid "F.DIST(Number; DegreesFreedom1; DegreesFreedom2 [; Cumulative])" +msgstr "" #. TeZSu #: 04060182.xhp @@ -35521,14 +35674,14 @@ msgctxt "" msgid "The inverse function is GAMMAINV." msgstr "倒數函式為 GAMMAINV。" -#. 5bF6b +#. ER624 #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3155436\n" "help.text" -msgid "GAMMADIST(Number; Alpha; Beta; C)" -msgstr "GAMMADIST(number; Alpha; Beta; K)" +msgid "GAMMADIST(Number; Alpha; Beta [; C])" +msgstr "" #. erGE4 #: 04060182.xhp @@ -35773,22 +35926,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_GEOMITTEL\">Returns the geometric mean of a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GEOMITTEL\">傳回範例的幾何平均值。</ahelp>" -#. T8r4b +#. YBnZG #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3153720\n" "help.text" -msgid "GEOMEAN(Number1; Number2; ...; Number30)" -msgstr "" - -#. UhYAQ -#: 04060182.xhp -msgctxt "" -"04060182.xhp\n" -"par_id3152585\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample." +msgid "GEOMEAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. EGwom @@ -35890,14 +36034,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_GTEST\">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GTEST\">計算觀察到 Z 統計量大於根據樣本計算所得之統計量的概率。</ahelp>" -#. Wi4MG +#. GeqDU #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3153274\n" "help.text" -msgid "ZTEST(Data; mu; Sigma)" -msgstr "ZTEST(Data; mu; Sigma)" +msgid "ZTEST(Data; mu [; Sigma])" +msgstr "" #. RKyE7 #: 04060182.xhp @@ -35962,14 +36106,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_Z_TEST_MS\">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GTEST\">計算觀察到 Z 統計量大於根據樣本計算所得之統計量的概率。</ahelp>" -#. efbeG +#. Ug83K #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id2953274\n" "help.text" -msgid "Z.TEST(Data; mu; Sigma)" -msgstr "ZTEST(Data; mu; Sigma)" +msgid "Z.TEST(Data; mu [; Sigma])" +msgstr "" #. 2peSH #: 04060182.xhp @@ -36034,22 +36178,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_HARMITTEL\">Returns the harmonic mean of a data set.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_HARMITTEL\">傳回資料集的調和平均值。</ahelp>" -#. xroLU +#. EKBXf #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3149287\n" "help.text" -msgid "HARMEAN(Number1; Number2; ...; Number30)" -msgstr "" - -#. gT7zX -#: 04060182.xhp -msgctxt "" -"04060182.xhp\n" -"par_id3154303\n" -"help.text" -msgid "<emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean." +msgid "HARMEAN(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" msgstr "" #. DMCH7 @@ -36088,13 +36223,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">傳回超幾何分佈。</ahelp>" -#. 5uQ3c +#. BEUMD #: 04060182.xhp msgctxt "" "04060182.xhp\n" "par_id3155388\n" "help.text" -msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])" +msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])" msgstr "" #. ingyW @@ -37033,14 +37168,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOGINV\">Returns the inverse of the lognormal distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LOGINV\">傳回對數常態分佈的逆運算。</ahelp>" -#. D9Eg5 +#. kK6DB #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3153049\n" "help.text" -msgid "LOGINV(Number; Mean; StDev)" -msgstr "LOGINV(Number; Mean; StDev)" +msgid "LOGINV(Number [; Mean [; StDev]])" +msgstr "" #. uqfDA #: 04060183.xhp @@ -37186,14 +37321,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the values of a lognormal distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_GAMMAVERT\">傳回 Gamma 分佈的值。</ahelp>" -#. FB6kb +#. r4obV #: 04060183.xhp msgctxt "" "04060183.xhp\n" "par_id3150686\n" "help.text" -msgid "LOGNORMDIST(Number; Mean; StDev; Cumulative)" -msgstr "LOGNORMDIST(Number; Mean; StDev; Cumulative)" +msgid "LOGNORMDIST(Number [; Mean [; StDev [; Cumulative]]])" +msgstr "" #. BiGC6 #: 04060183.xhp @@ -38275,14 +38410,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_NORMVERT\">Returns the density function or the normal cumulative distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_NORMVERT\">傳回密度函式或一般累計分佈。</ahelp>" -#. vgosP +#. Mogit #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3150613\n" "help.text" -msgid "NORMDIST(Number; Mean; StDev; C)" -msgstr "NORMDIST(Number; Mean; StDev; C)" +msgid "NORMDIST(Number; Mean; StDev [; C])" +msgstr "" #. CoXtp #: 04060184.xhp @@ -38590,14 +38725,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_POISSON\">Returns the Poisson distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_POISSON\">傳回普松分佈。</ahelp>" -#. hdmir +#. SH95D #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3146093\n" "help.text" -msgid "POISSON(Number; Mean; C)" -msgstr "POISSON(number; mean; K)" +msgid "POISSON(Number; Mean [; C])" +msgstr "" #. mZnNF #: 04060184.xhp @@ -38662,14 +38797,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_POISSON\">傳回普松分佈。</ahelp>" -#. MCzFk +#. JHGHg #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2946093\n" "help.text" -msgid "POISSON.DIST(Number; Mean; C)" -msgstr "POISSON(number; mean; K)" +msgid "POISSON.DIST(Number; Mean [; C])" +msgstr "" #. jnjk7 #: 04060184.xhp @@ -38950,13 +39085,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Returns the percentage rank of a value in a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">傳回範例中值的百分比排名。</ahelp>" -#. 43275 +#. AAjBU #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id3147238\n" "help.text" -msgid "PERCENTRANK(Data; Value; Significance)" +msgid "PERCENTRANK(Data; Value [; Significance])" msgstr "" #. hPEyS @@ -39031,13 +39166,13 @@ msgctxt "" msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." msgstr "" -#. 7KcdX +#. FFw3f #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2847238\n" "help.text" -msgid "PERCENTRANK.EXC(Data; Value; Significance)" +msgid "PERCENTRANK.EXC(Data; Value [; Significance])" msgstr "" #. paUED @@ -39112,13 +39247,13 @@ msgctxt "" msgid "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." msgstr "" -#. GHbGk +#. YfPDe #: 04060184.xhp msgctxt "" "04060184.xhp\n" "par_id2947238\n" "help.text" -msgid "PERCENTRANK.INC(Data; Value; Significance)" +msgid "PERCENTRANK.INC(Data; Value [; Significance])" msgstr "" #. QmR4b @@ -39409,14 +39544,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_RANG\">Returns the rank of a number in a sample.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_RANG\">傳回範例中數字的排序位置。</ahelp>" -#. EUgG4 +#. oVk4F #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3153250\n" "help.text" -msgid "RANK(Value; Data; Type)" -msgstr "RANK(number; ref; Order)" +msgid "RANK(Value; Data [; Type])" +msgstr "" #. AzAQx #: 04060185.xhp @@ -39508,14 +39643,14 @@ msgctxt "" msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." msgstr "" -#. aqAAg +#. f8zpD #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2953250\n" "help.text" -msgid "RANK.AVG(Value; Data; Type)" -msgstr "RANK(number; ref; Order)" +msgid "RANK.AVG(Value; Data [; Type])" +msgstr "" #. 9jn8F #: 04060185.xhp @@ -39607,14 +39742,14 @@ msgctxt "" msgid "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." msgstr "" -#. gTjX5 +#. bGAcu #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id2853250\n" "help.text" -msgid "RANK.EQ(Value; Data; Type)" -msgstr "RANK(number; ref; Order)" +msgid "RANK.EQ(Value; Data [; Type])" +msgstr "" #. mncnk #: 04060185.xhp @@ -41749,14 +41884,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WAHRSCHBEREICH\">Returns the probability that values in a range are between two limits.</ahelp> If there is no <item type=\"literal\">End</item> value, this function calculates the probability based on the principle that the Data values are equal to the value of <item type=\"literal\">Start</item>." msgstr "<ahelp hid=\"HID_FUNC_WAHRSCHBEREICH\">傳回兩個限度之間範圍中各個值的機率。</ahelp>若無 <item type=\"literal\">End</item> 值，此函式會根據資料值等於 <item type=\"literal\">Start</item> 值的原則來計算機率。" -#. Ffebs +#. GhGG7 #: 04060185.xhp msgctxt "" "04060185.xhp\n" "par_id3147330\n" "help.text" -msgid "PROB(Data; Probability; Start; End)" -msgstr "PROB(Data; Probability; Start; End)" +msgid "PROB(Data; Probability; Start [; End])" +msgstr "" #. Reoxn #: 04060185.xhp @@ -54250,130 +54385,130 @@ msgctxt "" msgid "The result is presented in the string format and has the character \"i\" or \"j\" as an imaginary unit." msgstr "" -#. 3yZht +#. CT9jZ #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id71584446760037\n" "help.text" -msgid "<variable id=\"string255_1\">String 1[; String 2][; … ;[String 255]]</variable>" +msgid "<variable id=\"string255_1\">String 1 [; String 2 [; … [; String 255]]]</variable>" msgstr "" -#. aZAJy +#. 2UTGE #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id631556228516997\n" "help.text" -msgid "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings, references to cells or to cell ranges of strings." +msgid "<emph>String 1, String 2, … , String 255</emph> are strings, references to cells or to cell ranges of strings." msgstr "" -#. Gx7GF +#. MFitb #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id401584447957914\n" "help.text" -msgid "<variable id=\"integer255_1\">Integer 1[; Integer 2][; … ;[Integer 255]]</variable>" +msgid "<variable id=\"integer255_1\">Integer 1 [; Integer 2 [; … [; Integer 255]]]</variable>" msgstr "" -#. sCxFS +#. yUDDY #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id1001584395844941\n" "help.text" -msgid "<emph>Integer 1[; Integer 2][; … ;[Integer 255]]</emph> are integers, references to cells or to cell ranges of integers." +msgid "<emph>Integer 1, Integer 2, … , Integer 255</emph> are integers, references to cells or to cell ranges of integers." msgstr "" -#. KJbXQ +#. B6MF9 #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id101584447971004\n" "help.text" -msgid "<variable id=\"number254_1\">Number 1[; Number 2][; … ;[Number 254]]</variable>" +msgid "<variable id=\"number254_1\">Number 1 [; Number 2 [; … [; Number 254]]]</variable>" msgstr "" -#. JPXDA +#. b96Za #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584305947010\n" "help.text" -msgid "<emph>Number 1[; Number 2][; … ;[Number 254]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgid "<emph>Number 1, Number 2, … , Number 254</emph> are numbers, references to cells or to cell ranges of numbers." msgstr "" -#. y6bDp +#. kEEQr #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id101584447970004\n" "help.text" -msgid "<variable id=\"number255_1\">Number 1[; Number 2][; … ;[Number 255]]</variable>" +msgid "<variable id=\"number255_1\">Number 1 [; Number 2 [; … [; Number 255]]]</variable>" msgstr "" -#. BXZo8 +#. QKcwi #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584395947010\n" "help.text" -msgid "<emph>Number 1[; Number 2][; … ;[Number 255]]</emph> are numbers, references to cells or to cell ranges of numbers." +msgid "<emph>Number 1, Number 2, … , Number 255</emph> are numbers, references to cells or to cell ranges of numbers." msgstr "" -#. AWCP7 +#. RLXz8 #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id291584447988879\n" "help.text" -msgid "<variable id=\"logical255_1\">Logical 1[; Logical 2][; … ;[Logical 255]]</variable>" +msgid "<variable id=\"logical255_1\">Logical 1 [; Logical 2 [; … [; Logical 255]]]</variable>" msgstr "" -#. CzEmY +#. JTdAs #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584395957010\n" "help.text" -msgid "<emph>Logical 1[; Logical 2][; … ;[Logical 255]]</emph> are boolean values, references to cells or to cell ranges of logical values." +msgid "<emph>Logical 1, Logical 2, … , Logical 255</emph> are boolean values, references to cells or to cell ranges of logical values." msgstr "" -#. cjCCW +#. unnEF #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id91584448008632\n" "help.text" -msgid "<variable id=\"complex255_1\">Complex 1[; Complex 2][; … ;[Complex 255]]</variable>" +msgid "<variable id=\"complex255_1\">Complex 1 [; Complex 2 [; … [; Complex 255]]]</variable>" msgstr "" -#. AfffT +#. NuCbV #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id931584335947010\n" "help.text" -msgid "<emph>Complex 1[; Complex 2][; … ;[Complex 255]]</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." +msgid "<emph>Complex 1, Complex 2, … ,Complex 255</emph> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form \"x+yi\" or \"x+yj\"." msgstr "" -#. SDfoG +#. jWF7Y #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id61584448028298\n" "help.text" -msgid "<variable id=\"reference255_1\">Reference 1[; Reference 2][; … ;[Reference 255]]</variable>" +msgid "<variable id=\"reference255_1\">Reference 1 [; Reference 2 [; … [; Reference 255]]]</variable>" msgstr "" -#. NwpZa +#. dxwtx #: ful_func.xhp msgctxt "" "ful_func.xhp\n" "par_id431584335947010\n" "help.text" -msgid "<emph>Reference 1[; Reference 2][; … ;[Reference 255]]</emph> are references to cells." +msgid "<emph>Reference 1, Reference 2, … ,Reference 255</emph> are references to cells." msgstr "" #. 8DbP2 @@ -55510,13 +55645,13 @@ msgctxt "" msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions." msgstr "" -#. mZwNV +#. 3DwLL #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id3153454\n" "help.text" -msgid "CEILING(Number[; Significance[; Mode]])" +msgid "CEILING(Number [; Significance [; Mode]])" msgstr "" #. XHjhc @@ -55555,13 +55690,13 @@ msgctxt "" msgid "<input>=CEILING(3.45)</input> returns 4." msgstr "" -#. ztdNi +#. UTtFZ #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id921586208142416\n" "help.text" -msgid "<input>=CEILING(3.45, 3)</input> returns 6." +msgid "<input>=CEILING(3.45; 3)</input> returns 6." msgstr "" #. XGfA3 @@ -55573,22 +55708,22 @@ msgctxt "" msgid "<input>=CEILING(-1.234)</input> returns -1." msgstr "" -#. ss5WP +#. ZWjxy #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id491586208152183\n" "help.text" -msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44." +msgid "<input>=CEILING(-45.67; -2; 0)</input> returns -44." msgstr "" -#. FY9XN +#. Auwyx #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id291586208158119\n" "help.text" -msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46." +msgid "<input>=CEILING(-45.67; -2; 1)</input> returns -46." msgstr "" #. rZ78k @@ -55636,13 +55771,13 @@ msgctxt "" msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function." msgstr "" -#. yYT7X +#. BASfr #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id2953454\n" "help.text" -msgid "CEILING.PRECISE(Number[; Significance])" +msgid "CEILING.PRECISE(Number [; Significance])" msgstr "" #. FaYeD @@ -55663,13 +55798,13 @@ msgctxt "" msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4." msgstr "" -#. kkosx +#. KxeUC #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id651586213406243\n" "help.text" -msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44." +msgid "<input>=CEILING.PRECISE(-45.67; 2)</input> returns -44." msgstr "" #. WV9bx @@ -55717,13 +55852,13 @@ msgctxt "" msgid "This function exists for interoperability with Microsoft Excel 2013 or newer." msgstr "" -#. Km7yb +#. pcXnS #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id841516997669932\n" "help.text" -msgid "CEILING.MATH(Number[; Significance[; Mode]])" +msgid "CEILING.MATH(Number [; Significance [; Mode]])" msgstr "" #. EAezJ @@ -55753,13 +55888,13 @@ msgctxt "" msgid "<input>=CEILING.MATH(3.45)</input> returns 4." msgstr "" -#. 6BkMe +#. g5xAQ #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id481586208595809\n" "help.text" -msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6." +msgid "<input>=CEILING.MATH(3.45; -3)</input> returns 6." msgstr "" #. Eby7i @@ -55771,22 +55906,22 @@ msgctxt "" msgid "<input>=CEILING.MATH(-1.234)</input> returns -1." msgstr "" -#. fH4Yt +#. T4orc #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id151586208604536\n" "help.text" -msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44." +msgid "<input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44." msgstr "" -#. MGVBD +#. opt6B #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id971586208611345\n" "help.text" -msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46." +msgid "<input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46." msgstr "" #. EzE9t @@ -55861,22 +55996,22 @@ msgctxt "" msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4." msgstr "" -#. SZYUC +#. nU46D #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id651586214132234\n" "help.text" -msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44." +msgid "<input>=CEILING.XCL(-45.67; 2)</input> returns -44." msgstr "" -#. pz8Go +#. nbB96 #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id811586214136666\n" "help.text" -msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46." +msgid "<input>=CEILING.XCL(-45.67; -2)</input> returns -46." msgstr "" #. GMzhD @@ -55924,13 +56059,13 @@ msgctxt "" msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function." msgstr "" -#. LZzHU +#. GRocX #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id8953454\n" "help.text" -msgid "ISO.CEILING(Number[; Significance])" +msgid "ISO.CEILING(Number [; Significance])" msgstr "" #. hwhCW @@ -55951,13 +56086,13 @@ msgctxt "" msgid "<input>=ISO.CEILING(3.45)</input> returns 4." msgstr "" -#. xS2zM +#. QHpJp #: func_ceiling.xhp msgctxt "" "func_ceiling.xhp\n" "par_id181586214438808\n" "help.text" -msgid "<input>=ISO.CEILING(-45.67,2)</input> returns -44." +msgid "<input>=ISO.CEILING(-45.67; 2)</input> returns -44." msgstr "" #. GuEcB @@ -55996,13 +56131,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." msgstr "" -#. wRAHQ +#. 3ubzF #: func_color.xhp msgctxt "" "func_color.xhp\n" "par_id27421466710275\n" "help.text" -msgid "COLOR(Red; Green; Blue; Alpha)" +msgid "COLOR(Red; Green; Blue [; Alpha])" msgstr "" #. ASLWJ @@ -57535,13 +57670,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable>" msgstr "" -#. yA9fg +#. 4ztby #: func_findb.xhp msgctxt "" "func_findb.xhp\n" "par_id221573517641172\n" "help.text" -msgid "FINDB( Find Text ; Text ; Position )" +msgid "FINDB(Find Text ; Text [; Position])" msgstr "" #. puQAw @@ -58768,13 +58903,13 @@ msgctxt "" msgid "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Computes the Discrete Fourier Transform [DFT] of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.</ahelp></variable> The function is an <link href=\"text/scalc/01/04060107.xhp\" name=\"array formula\">array formula</link>." msgstr "" -#. 467q3 +#. xGHaG #: func_fourier.xhp msgctxt "" "func_fourier.xhp\n" "par_id541556228253979\n" "help.text" -msgid "FOURIER(Array, GroupedByColumns, Inverse, Polar, MinimumMagnitude)" +msgid "FOURIER(Array; GroupedByColumns [; Inverse [; Polar [; MinimumMagnitude]]])" msgstr "" #. ELSK7 @@ -60487,13 +60622,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp>" msgstr "" -#. GB88f +#. 53kNC #: func_networkdays.intl.xhp msgctxt "" "func_networkdays.intl.xhp\n" "par_id231020162249539143\n" "help.text" -msgid "NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)" +msgid "NETWORKDAYS.INTL(StartDate; EndDate [; [ Weekend ] [; Holidays ] ])" msgstr "" #. D8jig @@ -60613,13 +60748,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_NETWORKDAYS\">Returns the number of workdays between a <emph>start date</emph> and an <emph>end date</emph>. Holidays can be deducted.</ahelp>" msgstr "" -#. shbHi +#. AME9S #: func_networkdays.xhp msgctxt "" "func_networkdays.xhp\n" "par_id3145775\n" "help.text" -msgid "NETWORKDAYS(StartDate; EndDate; Holidays; Workdays)" +msgid "NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])" msgstr "" #. BEtbU @@ -60802,13 +60937,13 @@ msgctxt "" msgid "Constraints: LEN(decimal_separator) = 1, decimal_separator shall not appear in group_separator" msgstr "" -#. xQzLz +#. 2uppP #: func_numbervalue.xhp msgctxt "" "func_numbervalue.xhp\n" "par_id3149268\n" "help.text" -msgid "NUMBERVALUE(\"Text\";decimal_separator;group_separator)" +msgid "NUMBERVALUE(\"Text\" [;decimal_separator [;group_separator]])" msgstr "" #. ytM82 @@ -60883,13 +61018,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable>" msgstr "" -#. FxbGq +#. 3ky3t #: func_opt_barrier.xhp msgctxt "" "func_opt_barrier.xhp\n" "par_id371575067051846\n" "help.text" -msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring; Greek)" +msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek])" msgstr "" #. XEMff @@ -61126,13 +61261,13 @@ msgctxt "" msgid "The function ignores the possibility of knock-out before maturity." msgstr "" -#. XTh5Y +#. DHFtE #: func_opt_prob_inmoney.xhp msgctxt "" "func_opt_prob_inmoney.xhp\n" "par_id761575075027094\n" "help.text" -msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier; Strike; PutCall)" +msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier [; Strike [; PutCall]])" msgstr "" #. mE6CG @@ -61207,13 +61342,13 @@ msgctxt "" msgid "Further information about touch / no-touch options may be found on many financial websites." msgstr "" -#. pyway +#. V3nnz #: func_opt_touch.xhp msgctxt "" "func_opt_touch.xhp\n" "par_id151575063296819\n" "help.text" -msgid "OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring; Greek)" +msgid "OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring [; Greek])" msgstr "" #. 6rD5u @@ -61918,13 +62053,13 @@ msgctxt "" msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions (not case sensitive).</ahelp></variable>" msgstr "" -#. jADhb +#. zQHHs #: func_searchb.xhp msgctxt "" "func_searchb.xhp\n" "par_id531573516878780\n" "help.text" -msgid "SEARCHB( Find text ; Text ; Position)" +msgid "SEARCHB(Find Text; Text [; Position])" msgstr "" #. 6Pmbf @@ -63061,13 +63196,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_WOCHENTAG\">Returns the day of the week for the given date value.</ahelp> The day is returned as an integer between 1 (Sunday) and 7 (Saturday) if no type or type=1 is specified. For other types, see the table below." msgstr "" -#. EDmeN +#. SaqiJ #: func_weekday.xhp msgctxt "" "func_weekday.xhp\n" "par_id3149033\n" "help.text" -msgid "WEEKDAY(Number[; Type])" +msgid "WEEKDAY(Number [; Type])" msgstr "" #. mcF52 @@ -63808,13 +63943,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Returns the date calculated from a start date with a specific number of work days, before or after the start date. The calculation can include week-ends and holidays as non-working days.</ahelp>" msgstr "" -#. ZFLiY +#. 9r2Ns #: func_workday.intl.xhp msgctxt "" "func_workday.intl.xhp\n" "par_id241020160008306838\n" "help.text" -msgid "WORKDAY.INTL(StartDate; Days[; Weekend][; Holidays])" +msgid "WORKDAY.INTL(StartDate; Days [; Weekend [; Holidays]])" msgstr "" #. gJg5G @@ -63979,13 +64114,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> The result is a date number that can be formatted as a date. You then see the date of a day that is a certain number of <emph>workdays</emph> away from the <emph>start date</emph>.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_WORKDAY\"> 結果是可格式化為日期的日期數字。接著，您會看到<emph>開始日期</emph>之後某天<emph>工作日</emph>的日期。</ahelp>" -#. fo6sg +#. NDtoU #: func_workday.xhp msgctxt "" "func_workday.xhp\n" "par_id3154844\n" "help.text" -msgid "WORKDAY(StartDate; Days[; Holidays])" +msgid "WORKDAY(StartDate; Days [; Holidays])" msgstr "" #. 35EG5 @@ -64168,13 +64303,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>" msgstr "" -#. AASCJ +#. DBBsL #: func_yearfrac.xhp msgctxt "" "func_yearfrac.xhp\n" "par_id3155823\n" "help.text" -msgid "YEARFRAC(StartDate; EndDate[; Basis])" +msgid "YEARFRAC(StartDate; EndDate [; Basis])" msgstr "" #. JAA8u |