Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

Excel-Formula: Math Formula – ROUND()

Description: 

The ROUND func­tion in MS excel returns a rounded num­ber based on the spec­i­fied num­ber of digits.

Format:

As Excel For­mula : ROUND(number,digits)

Note : ROUND() works slightly diffrent when used as VBA function.Click here to know about it VBA-ROUND()

Arguments:

  • Num­ber
    • Manda­tory
    • Type: Num­ber
    • Num­ber which requires to be rounded.
  • dig­its
    • Manda­tory
    • Type: Num­ber
    • Num­ber of dig­its to the num­ber to

Impor­tant Notes:

If num­ber you are round­ing ends with 5 then this func­tion will return the num­ber end­ing with near­est even num­ber, see example

Round(4.55,1)
Output: 4.6   (round up)

Round(6.85,1)
Output: 6.8 (round down)

Other Exam­ples:

Round(3.33,0)
Output: 3

Round(25.77,1)
Output: 25.8

Round(26.32)
Output: 26

Inter­est­ing Fact:

You can pro­vide –1 as dig­its argu­ment, in the case ROUND() will return the near­est Interger divis­i­ble by 10. see Example

Round(26.32,-1)
Output: 20

Round(13,-1)
Output: 10

Round(46,-1)
Output: 50
ROUND() Formula

ROUND() For­mula

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: