Formulas in Excel 1 – Round Numbers in Excel with Round Function to the Nearest Decimal or Integer



Premium Course:

Excel Forum:
Visit for more, including Excel Consulting, Macros, and Tutorials.

Round numbers in Excel using the Round Function. You will learn how to round a number to the nearest integer, to a specified number of decimals, as well as to a specified number of integers. This is a great tutorial to view to learn how to deal with numbers in Microsoft Excel and will save you a lot of time when manipulating numbers in Excel.

For Excel consulting or to get the spreadsheet or macro used here visit the website There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Nguồn: https://rmacct.org/

Xem thêm bài viết khác: https://rmacct.org/cong-nghe/

  • One Problem, I don't want the number to appear in a different cell, I want it to the number in a cell with the result being in the same cell.

    w Boyce June 29, 2020 6:40 pm Reply
  • I type 500 in excel and auto changes to 5.00 will some solve this problem

    shanta sapkota June 29, 2020 6:40 pm Reply
  • Can you let me know who to convert these decimal numbers to percentage ?

    Santosh Lilani June 29, 2020 6:40 pm Reply
  • Hey , can we roundup to nearest 5 ?

    Fahad Attiq June 29, 2020 6:40 pm Reply
  • I know it has been a decade since this video is uploaded, but how do I go to nearest (.99) ?

    hardik khatri June 29, 2020 6:40 pm Reply
  • Why do you keep getting .0000 ??? .000000 ???

    Umb Nmbu June 29, 2020 6:40 pm Reply
  • Hi mate, what if you don't deal with decimals ? What if you have 119 or 121 and you want to round it to 120? How you gonna do it?

    Petar T June 29, 2020 6:40 pm Reply
  • 234576 iske liye formula ???

    Jagdishchandra Khan June 29, 2020 6:40 pm Reply
  • This is so helpful thank you

    AshourLFC June 29, 2020 6:40 pm Reply
  • Thank you.

    Nagaraja Bartakke June 29, 2020 6:40 pm Reply
  • Am really grateful! You save my time and my life as well 🙂

    أمير الذوق June 29, 2020 6:40 pm Reply
  • thank u so much my problem is solved

    ali enterprises June 29, 2020 6:40 pm Reply
  • Great vedio sir

    Mohan Pal June 29, 2020 6:40 pm Reply
  • Thank you very much. You have saved me a lot of time. I wish I had seen this earlier.

    svijayiitk June 29, 2020 6:40 pm Reply
  • Thank you very much. You have saved me a lot of time. i wish I had seen this earlier.

    Andrew Mutambara June 29, 2020 6:40 pm Reply
  • Thanx

    Harish Goyal June 29, 2020 6:40 pm Reply
  • How to
    =G43*L27 Round to nearest whole number, no decimal???
    For answer on line G44

    ECLECTIC 361 June 29, 2020 6:40 pm Reply
  • thank you very much sir

    A P June 29, 2020 6:40 pm Reply
  • Thanks for this Video.
    While calculating salary increment we round up to next tens if the amount is like 8932 or 8407 or 8159
    BUT
    if the amount calculated is 8930.135 then we keep it to 8930 only.
    Here the [roundup(number, -1)] formula is calculating 8930.135 as 8940 too.
    Please help me with some formula to solve the issue.

    Rudra Kumar Thakur June 29, 2020 6:40 pm Reply
  • Did you ever think that perhaps we don't want all those useless zeroes after the decimal point?

    Justin Tym June 29, 2020 6:40 pm Reply
  • This is great thank you so much!

    Blondiesque _ June 29, 2020 6:40 pm Reply
  • your audio is very low. you should reload this again with better audio

    Richard Martin June 29, 2020 6:40 pm Reply
  • What's the rounding mode of round function? Is it ceiling?

    Julius Christian Atienza June 29, 2020 6:40 pm Reply
  • thanks

    Shamaila Majeed June 29, 2020 6:40 pm Reply
  • You helped me a lot, I wasted 1 hour trying to know how to adjust the number, with your video it take it less than 1 min, Thank you very much

    Alaa Shaghouri June 29, 2020 6:40 pm Reply
  • Hi, can we round the decimal on top of =SUM(A1,A2) formula?

    Shafiq69 June 29, 2020 6:40 pm Reply
  • great video straight to the point and easy to understand. Thank you vm! I subscribed.

    Dr. Mohamed Ait Nouh June 29, 2020 6:40 pm Reply
  • WHAT IF I HAVE A FLEET OF VEHICLES AND EACH HAS A 17 DIGIT VIN NUMBER BUT I ONLY WANT TO SEE THE LAST 6 DIGITS OF THAT #? CAN YOU HELP

    Gabriel Prieto June 29, 2020 6:40 pm Reply
  • This formula is The BEST to find STT CHARGE in STOCK MARKET… Thanks a lot…

    JDLearningTube June 29, 2020 6:40 pm Reply
  • My Computer Teacher recommended me to watch this vid

    IBilly999 June 29, 2020 6:40 pm Reply
  • Thanks a tonne saved my time . Your explanation is very clear.

    nidhi singh June 29, 2020 6:40 pm Reply
  • Many many thanks sir for this video

    DIGITAL WORLD June 29, 2020 6:40 pm Reply
  • pls round it to the nearest ten

    Carlisto shows June 29, 2020 6:40 pm Reply
  • Plz help me i want to round off ex. 112.13 figure i want to round off last 2 decimal in even figure ans is 112.14 how to do that any one plz help its urgent for me…………

    AmiT Tally Expert June 29, 2020 6:40 pm Reply
  • Thank you sir

    SyamAcademy June 29, 2020 6:40 pm Reply
  • NICE VIDEO DURING PRACTICAL EXAMINATIONS

    muralidhara acharya June 29, 2020 6:40 pm Reply
  • nice, r you know how to draw the circle in excel work sheet, with calculation , if we put any value circle increase or decrease according to value put in excel sheet……

    Ravi Sharma June 29, 2020 6:40 pm Reply
  • Nice bro!!! Awensome .

    Technical Ishmeet June 29, 2020 6:40 pm Reply
  • how do i do this without requiring an extra collumn]

    Black Watch OW June 29, 2020 6:40 pm Reply
  • thank you love u

    Neil Justin Ilao June 29, 2020 6:40 pm Reply
  • Thanks. Just what I needed.

    HowToExcel June 29, 2020 6:40 pm Reply
  • cant we round for example 22.24 to 22.25?can you please explain?

    Yamini Guttikonda June 29, 2020 6:40 pm Reply
  • my favorite math

    Aiman01 Piteilan June 29, 2020 6:40 pm Reply
  • hirap Yan Hindi ko geys

    pauleen Didal June 29, 2020 6:40 pm Reply
  • Great video, but is there a way to round within the same cell, or do I have to insert the result in the adjacent cell? And this method requires me to do the function for each cell. This takes more time than just entering it manually. Microsoft should have an easier way for such a basic function.

    Janadaan Kumaylah June 29, 2020 6:40 pm Reply
  • good presentation mate 🙂

    Kazi Safowan Shahed June 29, 2020 6:40 pm Reply
  • Thanks man… that really helped me…

    Faizan Alam June 29, 2020 6:40 pm Reply
  • If it appears there is an error in the fomula try use " ; " instead of " , "

    orionas Alexous June 29, 2020 6:40 pm Reply

Leave a Reply

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