Lines Matching refs:calculate
17410 …s in the drawing. In $[officename] Draw, you can use dimension lines to calculate and display line…
17753 … in the current sheet. You can define ranges, sort and filter the data, calculate results, outline…
17842 … sr $[officename] Calc is a spreadsheet application that you can use to calculate, analyze, and ma…
17852 …ges, or to format ranges according to special conditions, or to quickly calculate subtotals and to…
18469 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help tit 0 sr Calculating in Text Documen…
18470 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help bm_id3149909 0 sr \<bookmark_value\>…
18471 …text\swriter\guide\calculate.xhp 0 help hd_id3149909 1 0 sr \<variable id=\"calculate\"\>\<link …
18472 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help par_id3149949 2 0 sr You can insert a…
18473 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help par_id3149972 3 0 sr Click in the doc…
18474 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help par_id3155547 10 0 sr Type the calcul…
18475 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help par_id3155565 11 0 sr You can also cl…
18476 helpcontent2 source\text\swriter\guide\calculate.xhp 0 help par_id8316904 0 sr To reference cell…
18480 …xt already contains a formula, for example "12+24*2", $[officename] can calculate, and then paste …
18493 …able.xhp 0 help par_id3155533 11 0 sr Similarly, you can also quickly calculate the sum of a row…
18498 …ide\calculate_intext.xhp 0 help par_id3152901 26 0 sr For example, to calculate the mean value o…
24872 …hp 0 help par_id7109286 0 sr \<ahelp hid=\".\"\>Select a function to calculate the error bars.\…
24907 …h\>then the numbers 1, 2, 3, \<emph\>…\</emph\> are used as x-values to calculate the trend line. …
24921 helpcontent2 source\text\schart\01\04050100.xhp 0 help par_id7735221 0 sr You can also calculate…
24956 …omial regression\</emph\> curve cannot be added automatically. You must calculate this curve manua…
28260 …203685477.5808 to +922337203685477.5807. Currency variables are used to calculate currency values …
29847 … 0 sr \<item type=\"productname\"\>%PRODUCTNAME\</item\> Basic lets you calculate time or date dif…
29864 …tween December 30,1899 and the given date. You can use this function to calculate the difference b…
29886 …ate:\</emph\> String expression that contains the date that you want to calculate. The date can be…
29887 …er 31, 9999 into a single integer value. You can then use this value to calculate the difference b…
29936 …Integer expression that contains the serial date number that is used to calculate the day of the w…
29969 …Integer expression that contains the serial date number that is used to calculate the year. 201…
30160 …Numeric expression that contains the serial time number that is used to calculate the number of se…
30171 …meters that are passed as numeric value. You can then use this value to calculate the difference b…
30185 …al function to convert any time into a single value that you can use to calculate time differences…
30186 …al date values are calculated as days relative to a fixed date, you can calculate with values retu…
30199 …epresents the time in a single numeric value. This value can be used to calculate the difference b…
30205 …\</emph\> Any string expression that contains the time that you want to calculate in the format "H…
30206 …Value function to convert any time into a single value, so that you can calculate time differences…
30208 …ere serial date values result in days relative to a fixed date, you can calculate with the values …
30672 … Numeric expression that specifies an angle in radians that you want to calculate the cosine for. …
30698 …> Numeric expression that defines the angle in radians that you want to calculate the sine for. …
30705 …17 0 sr REM The side opposite the angle and the angle (in degrees) to calculate the length of th…
30725 … 0 sr \<emph\>Number:\</emph\> Any numeric expression that you want to calculate the tangent for …
30732 …17 0 sr REM The side opposite the angle and the angle (in degrees) to calculate the length of th…
30771 … 0 sr \<emph\>Number:\</emph\> Any numeric expression that you want to calculate the natural loga…
30773 …\text\sbasic\shared\03080202.xhp 0 help par_id3153968 10 0 sr You can calculate logarithms to an…
30838 …\shared\03080400.xhp 0 help par_id3159414 2 0 sr Use this function to calculate square roots. …
30848 … 0 sr \<emph\>Number:\</emph\> Any numeric expression that you want to calculate the square root …
30904 …p par_id3153381 9 0 sr The following example uses the Abs function to calculate the difference b…
36443 …nsion length bounded by guides.\</ahelp\> Dimension lines automatically calculate and display line…
37020 … 0 sr Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5…
37047 …guide\calc_timevalues.xhp 0 help par_id3149263 54 0 sr If you want to calculate time differences…
37051 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help tit 0 sr Calculating in Spreadsheets …
37052 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help bm_id3150791 0 sr \<bookmark_value\>sp…
37053 …rce\text\scalc\guide\calculate.xhp 0 help hd_id3150791 0 sr \<variable id=\"calculate\"\>\<link…
37054 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3146120 0 sr The following is an…
37055 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3153951 0 sr Click in a cell, an…
37056 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_idN10656 0 sr Press Enter. 2013…
37057 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_idN1065D 0 sr The cursor moves dow…
37058 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3155064 0 sr Enter another numbe…
37059 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_idN1066F 0 sr Press the Tab key. …
37060 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_idN10676 0 sr The cursor moves to …
37061 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3154253 0 sr Type in a formula, …
37062 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_idN1068B 0 sr Press Enter. 201…
37063 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3147343 0 sr The result of the f…
37064 helpcontent2 source\text\scalc\guide\calculate.xhp 0 help par_id3155378 0 sr When you edit a for…
37375 …ill be given a caption that also shows the formula that will be used to calculate the data. 201…
37640 …ek.xhp 0 help par_id3145171 2 0 sr With the help of Goal Seek you can calculate a value that, as…
37642 helpcontent2 source\text\scalc\guide\goalseek.xhp 0 help par_id3150871 4 0 sr To calculate annual…
37644 …articular return \<item type=\"literal\"\>I\</item\>. For this example, calculate how much capital…
37645 …type=\"literal\"\>7.5%\</item\>) in one cell each. Enter the formula to calculate the interest \<i…
37671 …be formatted as text. Because it is in text format, however, you cannot calculate with this number…
37756 …ed 10 numbers in Columns A and B (A1:A10 and B1:B10), and would like to calculate the sum of each …
37803 …calculate a result from values that are stored in other cells. Then, you set up a cell range where…
37809 helpcontent2 source\text\scalc\guide\multioperation.xhp 0 help par_id3146888 42 0 sr To calculate…
37991 …46 8 0 sr What distinguishes a relative reference? Assume you want to calculate in cell E1 the s…
37994 …t. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the …
38028 …\text\scalc\guide\rounding_numbers.xhp 0 help hd_id3154755 11 0 sr To calculate with the rounded…
38632 …opying an area to the clipboard, you can filter certain information and calculate values. This com…
39242 …calc\01\04060103.xhp 0 help par_id3146099 5 0 sr Use this function to calculate the amount of mo…
39243 …tem type=\"productname\"\>%PRODUCTNAME\</item\> Calc with automatically calculate the correct fact…
39255 … you enter references instead of these values into the formula, you can calculate any number of "I…
39259 …alc\01\04060103.xhp 0 help par_id3149886 21 0 sr Use this function to calculate the depreciation…
39267 … 5 years. The salvage value is to be 10,000 currency units. You want to calculate depreciation for…
39402 …mph\> (optional) is the estimated value. An iterative method is used to calculate the internal rat…
40151 …60368 370 0 sr \<ahelp hid=\"HID_FUNC_QUADRATESUMME\"\>If you want to calculate the sum of the s…
40782 …c\01\04060107.xhp 0 help par_idN11BA7 0 sr You can use SUMPRODUCT to calculate the scalar produ…
41478 …cause this would first evaluate 2 divided by 29 divided by 68, and then calculate the ISLEAPYEAR f…
42780 helpcontent2 source\text\scalc\01\04060181.xhp 0 help par_id3148728 10 0 sr To calculate the inte…
42844 …nal) can be 0 or False to calculate the probability density function. It can be any other value or…
43062 …...Number30\</emph\> are up to 30 values or ranges, that can be used to calculate the harmonic mea…
43551 …179 0 sr \<emph\>Number\</emph\> is the value at which to calculate the Weibull dist…
44148 …0000.xhp 0 help par_id3145674 2 0 sr Opens a submenu with commands to calculate tables and activ…
44298 …elp\>\</variable\> $[officename] uses the SUM function to automatically calculate the subtotal and…
44307 …968 4 0 sr Select the table or the area in the table that you want to calculate subtotals for, a…
44310 …>Use function\</emph\> box, select the function that you want to use to calculate the subtotals. …
44317 …C_SUBT_FUNC\"\>Select the mathematical function that you want to use to calculate the subtotals.\<…
44562 …<ahelp hid=\"HID_SC_PIVOTSUBT\"\>Specify the subtotals that you want to calculate.\</ahelp\> 20…
44564 …r \<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_NONE\"\>Does not calculate subtotals.\</ahe…
44568 …elect this option, and then click the type of subtotal that you want to calculate in the list.\</a…
44570 …_SCDLG_PIVOTSUBT:LB_FUNC\"\>Click the type of subtotal that you want to calculate. This option is …
44608 …als and the grand total, following the same rules as above, are used to calculate the following ex…
44779 …umber is determined by the date system that is used by $[officename] to calculate dates. 201306…
44823 …\</emph\> is an integer between 1583 and 9956 or 0 and 99. You can also calculate other holidays b…
44933 … a decimal is the result of the date system used under $[officename] to calculate date entries. …
44983 …xhp 0 help par_idN105DD 0 sr The WEEKNUM_ADD function is designed to calculate week numbers exa…
59469 …ared\optionen\01041000.xhp 0 help par_idN10864 0 sr Specifies how to calculate the position of …
59678 …7\</item\> in B6 to calculate the net price, and type the formula \<item type=\"literal\"\>=B6*0.1…
59679 …hp 0 help par_id3154760 63 0 sr Switch on the iterations to correctly calculate the formulas, ot…
59884 …ttom spacing of a paragraph to the top spacing of the next paragraph to calculate the total spacin…
60762 …e functions are so-called Aggregate functions. These are functions that calculate data to create s…
62228 …hared\explorer\database\rep_navigator.xhp 0 help hd_id311593 0 sr To calculate a sum for each c…
62230 …id5391399 0 sr Open the Groups entry and the group where you want to calculate the cost. 20…