|
|
1.
|
|
|
Calculate
|
| Context: |
|
01060500.xhp
tit
help.text
|
|
|
rpBm
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
2.
|
|
|
<bookmark_value>references; iterative (Calc)</bookmark_value> <bookmark_value>calculating;iterative references (Calc)</bookmark_value> <bookmark_value>iterative references in spreadsheets</bookmark_value> <bookmark_value>recursions in spreadsheets</bookmark_value> <bookmark_value>dates; default (Calc)</bookmark_value> <bookmark_value>dates; start 1900/01/01 (Calc)</bookmark_value> <bookmark_value>dates; start 1904/01/01 (Calc)</bookmark_value> <bookmark_value>case sensitivity;comparing cell contents (Calc)</bookmark_value> <bookmark_value>decimal places displayed (Calc)</bookmark_value> <bookmark_value>precision as shown (Calc)</bookmark_value> <bookmark_value>values; rounded as shown (Calc)</bookmark_value> <bookmark_value>rounding precision (Calc)</bookmark_value> <bookmark_value>search criteria for database functions in cells</bookmark_value> <bookmark_value>Excel; search criteria</bookmark_value>
|
| Context: |
|
01060500.xhp
bm_id3149399
help.text
|
|
|
(bGR
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
3.
|
|
|
<link href="text/shared/optionen/01060500.xhp" name="Calculate">Calculate</link>
|
| Context: |
|
01060500.xhp
hd_id3145071
1
help.text
|
|
|
Mrv/
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
4.
|
|
|
<ahelp hid=".">Defines the calculation settings for spreadsheets.</ahelp> Defines the behavior of spreadsheets with iterative references, the date settings, the number of decimal places, and if capitalization or lower cases are to be considered when searching within sheets.
|
| Context: |
|
01060500.xhp
par_id3147576
2
help.text
|
|
|
e=u@
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
5.
|
|
|
Iterative references
|
| Context: |
|
01060500.xhp
hd_id3149399
3
help.text
|
|
|
OmNF
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
6.
|
|
|
In this section you can delimit the number of approximation steps carried out during iterative calculations. In addition, you can specify the degree of precision of the answer.
|
| Context: |
|
01060500.xhp
par_id3155419
4
help.text
|
|
|
+^?m
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
7.
|
|
|
Iterations
|
| Context: |
|
01060500.xhp
hd_id3154142
5
help.text
|
|
|
P[1T
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
8.
|
|
|
<ahelp hid="SC:CHECKBOX:RID_SCPAGE_CALC:BTN_ITERATE">Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.</ahelp> If the<emph> Iterations </emph>box is not marked, an iterative reference in the table will cause an error message.
|
| Context: |
|
01060500.xhp
par_id3149795
6
help.text
|
|
|
D+[_
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
9.
|
|
|
<emph>Example:</emph> calculating the cost of an item without the value-added tax.
|
| Context: |
|
01060500.xhp
par_id3148686
7
help.text
|
|
|
t,Dg
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
|
|
10.
|
|
|
Type the text 'Selling price' in cell A5, the text 'Net' in cell A6, and the text 'Value-added tax' in cell A7.
|
| Context: |
|
01060500.xhp
par_id3156155
8
help.text
|
|
|
rI{k
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01060500.xhp
|
