The ROUNDDOWN & ROUNDUP Functions1:52 with Michael Watson
These functions round a calculation up or down. You can use it to avoid fractional values when calculating things like a number of seats in a stadium, or total number of employees needed to complete a project.
- you can continue to use the spreadsheet from the last video, or
- open a copy of this spreadsheet to catch up to this video
- Documentation for the ROUNDDOWN function for Google Sheets
- Documentation for the ROUNDUP function for Google Sheets
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