## Wednesday, November 18, 2009

### Excel Formula: Round()

Intermediate to advance users of Excel may be quite familiar with the formula "Round()" where one can round off decimals.

Microsoft offers something beyond decimals rounding off by this formula.

The usual syntax for rounding off a number is "Round(#ref,1)" where #ref is the cell reference or the number to be rounded off and 1 is the number of decimal places the number needs to be rounded off i.e. if you want two digits after the decimal it should be 2, for one digit it should be 1 and no digits after decimal it should be 0.

Have you ever tried using -ve number for rounding off...?

Yes..! Using a negative number in the syntax will round of the number to the unit place you desire i.e. "Round(#ref,-1)". Eg: You wish to round off 123456 to the nearest thousands so the formula would be "Round(123456,-3)" - Result: 123000!!

This would be quite handy for the finance and sales people who need to quote rounded figures at various forums..!!

Microsoft excel rocks..!

#### 1 comment:

1. The article where you can get the knowledge in the better way and you can groom in a way that it's easy for you to tackle any problem in your life. You can also go for the link of cheap essay writing services and get the new blog with the best session.