writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 8:
Line 8: − + Line 18:
Line 18: − + − + − + − +
no edit summary
=ROUND(number, num_of_digits)=
<div style="font-size:30px">'''ROUND(Number,Decimals)'''</div><br/>
*Where 'number' is the number to round and
*Where 'Number' is the number to round and
*'num_of_digits' is the number of digits to which the number is to be rounded.
*'Decimals' is the number of digits to which the number is to be rounded.
ROUND() rounds a number to specified number of digits.
ROUND() rounds a number to specified number of digits.
== Description ==
== Description ==
ROUND(number, num_of_digits)
ROUND(Number,Decimals)
This function is used to round a number to certain number of digits mentioned in the argument.
This function is used to round a number to certain number of digits mentioned in the argument.
ROUND(411.3,-1) ''returns 410'' as a result.
ROUND(411.3,-1) ''returns 410'' as a result.
*If 'num_of_digits' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
*If 'Decimals' is omitted, Calci assumes it to be zero and rounds the number to the nearest integer.
*The number is rounded to the specified number of decimal places, if num_of_digits > 0.
*The number is rounded to the specified number of decimal places, if Decimals > 0.
*The number is rounded to the nearest integer, if num_of_digits = 0.
*The number is rounded to the nearest integer, if Decimals = 0.
*The number is rounded to the left of the decimal point, if num_of_digits < 0.
*The number is rounded to the left of the decimal point, if Decimals < 0.
*If any argument is non-numeric, Calci displays #NaN error message.
*If any argument is non-numeric, Calci displays #NaN error message.