Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English

The explanation of the individual steps in detail

To create a manual rounding for an account calculation/aggregate of accounts:

1. 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.

2. Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group.

3. In the selection dialogue that then appears, select the option “Master value”. The task pane “Insert values” opens on the right.

4. Select “Account calculations and account aggregates” from the drop-down menu under “Data type”.

5. Then assign the desired account group and the desired key date.

6. Select an account calculation or account aggregate below.

7. Click on the symbol “Open the rounding wizard” in the group “Actions”. The rounding wizard opens.

8. Select manual rounding in the drop-down menu under “Rounding type”.

9. Enter the desired value under “Manual rounding value”.

10. Confirm your entry with “Ok”.

11. Select the rounded account calculation/account aggregate in the task pane.

12. Click on the button “Insert selected value” in the group “Actions”. The account calculation/account aggregate is inserted.