Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800…“) |
Keine Bearbeitungszusammenfassung |
||
Zeile 3: | Zeile 3: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | ||
<div style="font-weight:bolder;line-height:1.8;"> | <div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div> | ||
<div class="mw-collapsible-content"> | <div class="mw-collapsible-content"> | ||
<p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br> | <p align="left">To create a manual rounding for an account calculation/aggregate of accounts: <br><br> |
Version vom 23. August 2021, 13:20 Uhr
To create a manual rounding for an account calculation/aggregate of accounts:
-
Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.
-
Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group.
-
In the selection dialogue that then appears, select the option “Master value”. The task pane “Insert values” opens on the right.
-
Select “Account calculations and account aggregates” from the drop-down menu under “Data type”.
-
Then assign the desired account group and the desired key date.
-
Select an account calculation or account aggregate below.
-
Click on the symbol “Open the rounding wizard” in the group “Actions”. The rounding wizard opens.
-
Select manual rounding in the drop-down menu under “Rounding type”.
-
Enter the desired value under “Manual rounding value”.
-
Confirm your entry with “Ok”.
-
Select the rounded account calculation/account aggregate in the task pane.
-
Click on the button “Insert selected value” in the group “Actions”. The account calculation/account aggregate is inserted.