Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English
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.