Register now or log in to join your professional community.
round functiipn is used to control the decimal increase it or decrease it by roundup and rounddown functions=round(1.56,1) the output will be 1.6
Round function rounds off the number to desired digits after decimal which may be defined in the formula.
Relevant formulae are roundup (more digits after decimal) and rounddown (less digits after decimal).
The Round function rounds a number to a specified number of digits. if you want to round a number to the nearest whole number then we can use this function.
e.g.1) = Round (9.6745,2) gives result9.67
2) =Round (9.6767,2) gives result9.68