Excel formula tutorial: Working with ROUND, ROUNDUP, and ROUNDDOWN | lynda.com



With ROUND, ROUNDUP, AND ROUNDDOWN you can increase the accuracy of your data. Find out how to use these functions in this tutorial. Watch more at

This tutorial is a single movie from the Excel 2013: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The complete course duration is 5 hours and 26 minutes long and demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.

Introduction
1. Formula and Function Tips and Shortcuts
2. Formula and Function Tools
3. IF and Related Functions
4. Lookup and Reference Functions
5. Power Functions
6. Statistical Functions
7. Math Functions
8. Date and Time Functions
9. Array Formulas and Functions
10. Reference Functions
11. Text Functions
12. Information Functions
Conclusion

Nguồn: https://mechoimages.com/

Xem thêm bài viết khác: https://mechoimages.com/tong-hop/


Article Categories:
Tổng Hợp

Comments

  • Thank you

    Aravind Kamath June 19, 2020 12:32 am Reply
  • Thankssssssssssssssssssss!

    Villas de Labradores 2 June 19, 2020 12:32 am Reply
  • Thank you!

    Hsiao Fhong Tan June 19, 2020 12:32 am Reply
  • thanks .. i was confused

    mlnfish June 19, 2020 12:32 am Reply
  • very very very bad tutorial!!!!!!! nothing useful!!!!! be more practical!!!!!!!!!!!!!!!!!!!!!!!!!

    mariam rostomashvili June 19, 2020 12:32 am Reply
  • TO SLOW

    INTERNETSUPERSTAR VIDEOS June 19, 2020 12:32 am Reply
  • This man, and his majestic excel voice, just saved my life.

    necronorris June 19, 2020 12:32 am Reply
  • …… What should decrease desimall help me with…

    Outland Kristiansand June 19, 2020 12:32 am Reply
  • his voice pisses me off

    Brandon Taylor June 19, 2020 12:32 am Reply
  • Very confusing…

    ꧁༻JυʂƚZαȥȥყ༻꧂ June 19, 2020 12:32 am Reply
  • Your video is not clear

    L. Quelemine June 19, 2020 12:32 am Reply
  • i dont under stand your voice

    Jean Josua Maguddayao Bundalian June 19, 2020 12:32 am Reply
  • Thank you. Have been looking everywhere to figure out how to include a "round" function formula into another formula (maximum, minimum, average). This is exactly what I needed!

    Ozi Ostrich June 19, 2020 12:32 am Reply
  • Ahhh!!! This is exactly what I was looking for! I couldn't figure out how to round using a formula and the function!

    Zach Hug June 19, 2020 12:32 am Reply
  • great tutorial!

    Mohammed Kawasmi June 19, 2020 12:32 am Reply
  • Hi,

    I done that roundup option for estimating materials requirement.

    4.25 is entering as whole number of 5 but when am multiplying with 20 it should give 100/- . Since am getting 85/- only. Kindly do the needful.

    Seyad Sadham hussain June 19, 2020 12:32 am Reply
  • Great info , many thanks

    Kevin McCormack June 19, 2020 12:32 am Reply
  • THANK YOU VERY MUCH, I AM SAVED TODAY!!! hehehe

    Reenthroned Prof June 19, 2020 12:32 am Reply
  • its good 🙂

    Mohanvir Singh June 19, 2020 12:32 am Reply
  • Phone Booth movie ?

    PENnPAPER June 19, 2020 12:32 am Reply
  • Hwhat

    KD Harp June 19, 2020 12:32 am Reply
  • TLC4Sher, did you figure it out? Im trying to do ithat now, I need if the number is more than 4.10 it rounds up and if is 4.09 to round down, can you help me please

    Noelle Contreras June 19, 2020 12:32 am Reply
  • So helpful, thank you!

    Beth Bugnell June 19, 2020 12:32 am Reply
  • I don't know why it works on your computer, but when I hit the "increase decimal" button, it just adds decimal places to the ALREADY rounded number. Which means its just adding zeros. Which means its completely fucking useless and it makes me want to bring my computer to Bill Gates and throw it at his fucking head for allowing the creation of such an inane function!

    Science Matters June 19, 2020 12:32 am Reply
  • @ TLC4Sher – I would try to use a multiplier, 200 in your case, round, then divide by the 200…

    Steve Radell June 19, 2020 12:32 am Reply
  • Omg!! This totally makes sense.
    The increase, decrease decimal option in Excel doesn't change the value AT ALL!
    That's why there's errors in my calculations when I use the calculator.
    THANK YOU SO MUCH!!

    Coouge June 19, 2020 12:32 am Reply
  • I need your help.
    I tried your tutorial on my work & it didn't work….can you tell me what l should be doing
    ……
    I need to make a cell round up when .005 or more & round down when .005 is less whilst a formula is already in the cell….

    Does this make sense?

    Sherry Fancy June 19, 2020 12:32 am Reply

Leave a Comment

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