number is the number that is to be rounded.
increment is the number to whose multiple the value is to be rounded.
mode is an optional value. If the mode value is given and not equal to zero, and if number and increment are negative, rounding is done based on the absolute value of number. This mode argument is ignored when exporting to Microsoft Excel because it does not use a third parameter.
If both number
are negative and the mode
value is equal to zero or is not given, the results in IBM Docs and Microsoft Excel differ after the import is complete. If you export the spreadsheet to Excel, use mode=1 to see the same results in Excel as in IBM Docs.
Parent topic: Functions