The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
1. Technical terms makes confusion, so I will show you the result of it.
Start with 'ROUND', insert function 'ROUND' with omitted 'Count'.
Cell C1 is the result, A1 is the input.
Number without decimal is intact.
Setting 'Count' to 2 made no change.
Count: 2, input has one decimal, input is intact.
Changed Count to 1, input was intact.
Input with 4 decimals, the result was modified to 1 decimal
Now you should know that 'Count' has things to do with decimals.
If 'Count' is omitted, decimals will be removed.
Input with 3 decimals will be affected, if 'Count' is 2. The result will have 2 decimals.
In this case, if decimal 3 is 5 or greater, 'ROUND' will add 1 to decimal 2.
If decimal 3 is less than 5, decimal 2 is intact.
If 'Count' is negative, decimals will be removed, 55 was changed to 60 (see the picture below).
If input is 54, result is 50. 60 and 50 can be devided by 10 and the answer has no decimals.
5 is a half way to 10, so anything that is 5 or greater, 'ROUND' with negative 'Count' value will add some to that number to create the result that can be devided by 10 and the answer has no decimals. Anything that is less than 5, 'Round' will deducts that number to create the result that can be devided by 10 and the answer has no decimals.
What 'ROUND' with negative 'Count' value adds/deducts is not greater than 10.
The test steps - LibreOffice 7.5.2.2
OS: Windows 11 Home
Download from the developer's website: https://www.libreoffice.org/download/download-libreoffice
No comments:
Post a Comment