Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
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.
This is helpful if you're trying to calculate how many humans you'll need for
something, or whether or
not you have enough seating capacity in a stadium, for example.
Let's walk through an example together.
Here, we're talking about student to teacher ratios.
So our goal is to have a student to teacher ratio of 30.
We have 435 students, so that means that we need 14.5 teachers.
Now clearly, you can't have half a person,
so we can use round down or round up to help for this.
So, I'm gonna hit Enter, then =ROUNDUP to call the function.
Then we have teachers needed 14.5 and
I wanna round it to zero decimal places.
So we round up from 14.5, that gets us 15, so we need 15 teachers.
Let's say our budget was tight and
we didn't have the funds to afford to have extra capacity.
In this situation, we might use the round down function.
And just deal with the fact that we're gonna have a student to teacher ratio
above what we want for a little bit of time.
So the value rounds down to 14.
We can also do it, instead of referencing the cell above,
we're actually referencing the calculation we're interested in.
So I do ROUNDDOWN(C22/C21),
and we get the same thing.
You need to sign up for Treehouse in order to download course files.Sign up