Articles → EXCEL FORMULA → Round Function In Excel

Round Function In Excel

In this article, we will discuss round function in excel

What Is Rounding Of Numbers?

Rounding of numbers (decimal numbers) means replacing it with another value which is approximately equal to the original value. For example

Rounding of .999 is 1
Rounding of .777 is .78

But the question is – why do we need rounding of decimal numbers. The answer is, the value obtained from rounding of decimal number is easy to report.

For example, telling the HR of a company that your current salary is 49999.99 rupee is more frustrating, but rather you can say that my current salary is approximately 50000 rupees.

Round Function

Purpose of round function is to round the decimal value.

Syntax

=Round(number,number_digits)

In the above syntax

Number – Decimal number to round off.
Number_digits –.Number of digits to which decimal number is round off.

Example

Picture showing the output of Round function in excel

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Sunday, January 1, 2017

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**