Vorlage:Video-Kontenberechnung auf automatisiertem Arbeitsblatt-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (4 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 2: | Zeile 2: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <center> | ||
<div style="font-weight:bolder;line-height:1.8;">The explanation of each step in detail</div> | <div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | ||
<div class="mw-collapsible-content"> | <div style="font-weight:bolder;line-height:1.8;">The explanation of each step in detail</div> | ||
<p align="left">This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left">This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet: <br><br> | |||
<ol> | <ol> | ||
<li> <p align="left">Go to the automated worksheet</li> | |||
Note: You must always select an empty cell so that the result of the account calculation/account aggregate can be inserted there.</li> | <li> <p align="left">In the master value column, select the cells with the values you want to use for the account calculation/account aggregate. | ||
<p align="left"> '''Note:''' You must always select an empty cell so that the result of the account calculation/account aggregate can be inserted there.</li> | |||
<li> <p align="left"> Click the "Sum" button in the "Formulas" group in the "*Design" ribbon. | |||
<br> → The "Account calculation/Create account aggregate" dialog appears. Here you need to define a unique name for the account calculation used, as well as select the account group in which the account values needed for the account calculation are located.</li> | |||
<li> <p align="left"> From the list area with all account values, left-click to select the account values you want to add - and right-click to subtract. Optionally, you can also set a mathematical operator, a factor and an automatic rounding of the result.</li> | |||
<li> <p align="left">Confirm the dialog with "OK". | |||
<br> → The account calculation/account aggregate is displayed to you in the master value column and automatically written to the MeetingPoint. </li> | |||
</ol> | </ol> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 9. August 2023, 08:12 Uhr
This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet:
-
Go to the automated worksheet
-
In the master value column, select the cells with the values you want to use for the account calculation/account aggregate.
Note: You must always select an empty cell so that the result of the account calculation/account aggregate can be inserted there.
-
Click the "Sum" button in the "Formulas" group in the "*Design" ribbon.
→ The "Account calculation/Create account aggregate" dialog appears. Here you need to define a unique name for the account calculation used, as well as select the account group in which the account values needed for the account calculation are located. -
From the list area with all account values, left-click to select the account values you want to add - and right-click to subtract. Optionally, you can also set a mathematical operator, a factor and an automatic rounding of the result.
-
Confirm the dialog with "OK".
→ The account calculation/account aggregate is displayed to you in the master value column and automatically written to the MeetingPoint.