Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the meaning of function Round in Microsoft excel?

user-image
Question added by Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)
Date Posted: 2015/04/29
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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

Mohammad Athar
by Mohammad Athar , Senior Accountant , Techno

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).

Vina Sankaranarayanan
by Vina Sankaranarayanan , Operation Executive , BNY Mellon PVT LTD

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

More Questions Like This