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