"Swift 2.0 Basics" was retired on May 31, 2020. You are now viewing the recommended replacement.

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

    The round up and round down function help you round values in your formulas. 0:00
    This is helpful if you're trying to calculate how many humans you'll need for 0:04
    something, or whether or 0:08
    not you have enough seating capacity in a stadium, for example. 0:09
    Let's walk through an example together. 0:12
    Here, we're talking about student to teacher ratios. 0:15
    So our goal is to have a student to teacher ratio of 30. 0:19
    We have 435 students, so that means that we need 14.5 teachers. 0:23
    Now clearly, you can't have half a person, 0:29
    so we can use round down or round up to help for this. 0:32
    So, I'm gonna hit Enter, then =ROUNDUP to call the function. 0:37
    Then we have teachers needed 14.5 and 0:45
    I wanna round it to zero decimal places. 0:52
    So we round up from 14.5, that gets us 15, so we need 15 teachers. 0:59
    Let's say our budget was tight and 1:07
    we didn't have the funds to afford to have extra capacity. 1:09
    In this situation, we might use the round down function. 1:13
    And just deal with the fact that we're gonna have a student to teacher ratio 1:16
    above what we want for a little bit of time. 1:20
    So the value rounds down to 14. 1:23
    We can also do it, instead of referencing the cell above, 1:26
    we're actually referencing the calculation we're interested in. 1:29
    So I do ROUNDDOWN(C22/C21), 1:33
    and we get the same thing. 1:43

    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