Blog

Round Formulas in Microsoft Excel

Round Formulas in Microsoft Excel

 

We can use a variety of formulas for round the numbers in Excel depending on the situation , We have many formulas for like, Int, Round, Roundup, Round down, Ceiling and Floor etc.

So here we discussing some of the important formulas in Rounding Scenarios

 

Integer Formulas

What does it do?

Rounds down to nearest integer

 


Round Formulas

What does it do?

Rounds a number to specified decimal points (or multiples of 10)

 




Roundup Formulas

What does it do?

Rounds up a number

Round down Formulas

What does it do?

Rounds down a number


 



CEILING

What does it do?

Rounds up a number to the nearest multiple of 1,10,100…

FLOOR

Rounds down a number to the nearest multiple of 1,10,100…

 


 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.