Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Spreadsheet Basics

Well done!

You have completed Spreadsheet Basics!

Sign up for Treehouse Back to Library

The ROUNDDOWN & ROUNDUP Functions

1:52 with Michael Watson

These functions round a calculation up or down. You can use it to avoid fractional values when calculating things like the number of seats in a stadium, or the total number of employees needed to complete a project.

Example Files

  • you can continue to use the spreadsheet from the last video, or
  • open a copy of this spreadsheet to catch up to this video

Reference

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    something, or whether or 0:00
    not you have enough seating capacity in a stadium, for example. 0:00
    Let's walk through an example together. 0:03
    Here, we're talking about student to teacher ratios. 0:06
    So our goal is to have a student to teacher ratio of 30. 0:10
    We have 435 students, so that means that we need 14.5 teachers. 0:14
    Now clearly, you can't have half a person, 0:20
    so we can use round down or round up to help for this. 0:23
    So, I'm gonna hit Enter, then =ROUNDUP to call the function. 0:28

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up